Dataset statistics
| Number of variables | 43 |
|---|---|
| Number of observations | 28953 |
| Missing cells | 501215 |
| Missing cells (%) | 40.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 9.5 MiB |
| Average record size in memory | 344.0 B |
Variable types
| Unsupported | 5 |
|---|---|
| Categorical | 20 |
| Numeric | 18 |
CEOANN has constant value "" | Constant |
PCEO has constant value "" | Constant |
PCFO has constant value "" | Constant |
CONAME has a high cardinality: 386 distinct values | High cardinality |
COMMENT has a high cardinality: 1413 distinct values | High cardinality |
BECAMECEO has a high cardinality: 559 distinct values | High cardinality |
JOINED_CO has a high cardinality: 564 distinct values | High cardinality |
LEFTOFC has a high cardinality: 659 distinct values | High cardinality |
LEFTCO has a high cardinality: 780 distinct values | High cardinality |
TITLE has a high cardinality: 2655 distinct values | High cardinality |
EXEC_LNAME has a high cardinality: 3976 distinct values | High cardinality |
EXEC_FNAME has a high cardinality: 811 distinct values | High cardinality |
CUSIP has a high cardinality: 386 distinct values | High cardinality |
TICKER has a high cardinality: 386 distinct values | High cardinality |
REPRICE is highly imbalanced (96.2%) | Imbalance |
GENDER is highly imbalanced (76.1%) | Imbalance |
CFOANN has 28953 (100.0%) missing values | Missing |
EXECRANK has 28747 (99.3%) missing values | Missing |
CEOANN has 24685 (85.3%) missing values | Missing |
PENSION_CHG has 28953 (100.0%) missing values | Missing |
TOTAL_SEC has 28953 (100.0%) missing values | Missing |
CHG_CTRL_PYMT has 28953 (100.0%) missing values | Missing |
AGE has 18708 (64.6%) missing values | Missing |
EXECRANKANN has 7094 (24.5%) missing values | Missing |
TDC1 has 4801 (16.6%) missing values | Missing |
SAL_PCT has 5288 (18.3%) missing values | Missing |
TOTAL_CURR_PCT has 5283 (18.2%) missing values | Missing |
TOTAL_SEC_PCT has 28953 (100.0%) missing values | Missing |
TDC1_PCT has 10584 (36.6%) missing values | Missing |
COMMENT has 26778 (92.5%) missing values | Missing |
BECAMECEO has 20979 (72.5%) missing values | Missing |
JOINED_CO has 19336 (66.8%) missing values | Missing |
REJOIN has 28787 (99.4%) missing values | Missing |
LEFTOFC has 21623 (74.7%) missing values | Missing |
LEFTCO has 20082 (69.4%) missing values | Missing |
RELEFT has 28883 (99.8%) missing values | Missing |
PCEO has 28285 (97.7%) missing values | Missing |
PCFO has 28858 (99.7%) missing values | Missing |
REASON has 20141 (69.6%) missing values | Missing |
PAGE has 7491 (25.9%) missing values | Missing |
TDC1 is highly skewed (γ1 = 26.79319677) | Skewed |
ALLOTHTOT is highly skewed (γ1 = 45.88204098) | Skewed |
ALLOTHPD is highly skewed (γ1 = 61.41823403) | Skewed |
SAL_PCT is highly skewed (γ1 = 64.95114336) | Skewed |
TOTAL_CURR_PCT is highly skewed (γ1 = 39.72659118) | Skewed |
TDC1_PCT is highly skewed (γ1 = 64.95675232) | Skewed |
CFOANN is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
PENSION_CHG is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
TOTAL_SEC is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
CHG_CTRL_PYMT is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
TOTAL_SEC_PCT is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
BONUS has 2849 (9.8%) zeros | Zeros |
ALLOTHTOT has 2466 (8.5%) zeros | Zeros |
ALLOTHPD has 26385 (91.1%) zeros | Zeros |
SAL_PCT has 2347 (8.1%) zeros | Zeros |
TOTAL_CURR_PCT has 424 (1.5%) zeros | Zeros |
Reproduction
| Analysis started | 2023-04-27 19:12:41.593834 |
|---|---|
| Analysis finished | 2023-04-27 19:13:39.287706 |
| Duration | 57.69 seconds |
| Software version | ydata-profiling vv4.0.0 |
| Download configuration | config.json |
CFOANN
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 28953 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 226.3 KiB |
EXECDIR
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 226.3 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 28953 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 19666 | |
| 1 | 9287 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 19666 | |
| 1 | 9287 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 19666 | |
| 1 | 9287 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 28953 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 19666 | |
| 1 | 9287 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 28953 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 19666 | |
| 1 | 9287 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 28953 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 19666 | |
| 1 | 9287 |
REPRICE
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 226.3 KiB |
| 0 | |
|---|---|
| 1 | 117 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 28953 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 28836 | |
| 1 | 117 | 0.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 28836 | |
| 1 | 117 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 28836 | |
| 1 | 117 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 28953 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 28836 | |
| 1 | 117 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 28953 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 28836 | |
| 1 | 117 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 28953 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 28836 | |
| 1 | 117 | 0.4% |
EXECRANK
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | 3.4% |
| Missing | 28747 |
| Missing (%) | 99.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4368932 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 226.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 6 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.7372246 |
|---|---|
| Coefficient of variation (CV) | 0.712885 |
| Kurtosis | -0.16554224 |
| Mean | 2.4368932 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.0202751 |
| Sum | 502 |
| Variance | 3.0179493 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 93 | 0.3% |
| 2 | 38 | 0.1% |
| 3 | 24 | 0.1% |
| 5 | 17 | 0.1% |
| 4 | 16 | 0.1% |
| 6 | 14 | < 0.1% |
| 7 | 4 | < 0.1% |
| (Missing) | 28747 |
| Value | Count | Frequency (%) |
| 1 | 93 | |
| 2 | 38 | |
| 3 | 24 | 0.1% |
| 4 | 16 | 0.1% |
| 5 | 17 | 0.1% |
| 6 | 14 | < 0.1% |
| 7 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 7 | 4 | < 0.1% |
| 6 | 14 | < 0.1% |
| 5 | 17 | 0.1% |
| 4 | 16 | 0.1% |
| 3 | 24 | 0.1% |
| 2 | 38 | |
| 1 | 93 |
CO_PER_ROL
Real number (ℝ)
| Distinct | 5173 |
|---|---|
| Distinct (%) | 17.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13451.388 |
| Minimum | 1 |
|---|---|
| Maximum | 36815 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 226.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 702 |
| Q1 | 3914 |
| median | 13342 |
| Q3 | 21541 |
| 95-th percentile | 28917 |
| Maximum | 36815 |
| Range | 36814 |
| Interquartile range (IQR) | 17627 |
Descriptive statistics
| Standard deviation | 9627.1892 |
|---|---|
| Coefficient of variation (CV) | 0.71570228 |
| Kurtosis | -1.2503652 |
| Mean | 13451.388 |
| Median Absolute Deviation (MAD) | 8980 |
| Skewness | 0.18137482 |
| Sum | 3.8945804 × 108 |
| Variance | 92682772 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2593 | 14 | < 0.1% |
| 7995 | 14 | < 0.1% |
| 2865 | 14 | < 0.1% |
| 3816 | 14 | < 0.1% |
| 3817 | 14 | < 0.1% |
| 6562 | 14 | < 0.1% |
| 6564 | 14 | < 0.1% |
| 2816 | 14 | < 0.1% |
| 3861 | 14 | < 0.1% |
| 7996 | 14 | < 0.1% |
| Other values (5163) | 28813 |
| Value | Count | Frequency (%) |
| 1 | 7 | |
| 2 | 10 | |
| 3 | 12 | |
| 4 | 11 | |
| 5 | 3 | < 0.1% |
| 6 | 7 | |
| 7 | 7 | |
| 8 | 9 | |
| 9 | 3 | < 0.1% |
| 10 | 6 |
| Value | Count | Frequency (%) |
| 36815 | 2 | < 0.1% |
| 36813 | 1 | < 0.1% |
| 36804 | 2 | < 0.1% |
| 36803 | 2 | < 0.1% |
| 36802 | 5 | |
| 36730 | 3 | |
| 36729 | 4 | |
| 36728 | 4 | |
| 36188 | 5 | |
| 36186 | 2 | < 0.1% |
CONAME
Categorical
| Distinct | 386 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 226.3 KiB |
| PG&E CORP | 138 |
|---|---|
| EDISON INTERNATIONAL | 124 |
| SCHWAB (CHARLES) CORP | 118 |
| CONOCOPHILLIPS | 112 |
| FORD MOTOR CO | 111 |
| Other values (381) |
Length
| Max length | 28 |
|---|---|
| Median length | 21 |
| Mean length | 16.821228 |
| Min length | 5 |
Characters and Unicode
| Total characters | 487025 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | AMERICAN AIRLINES GROUP INC |
|---|---|
| 2nd row | AMERICAN AIRLINES GROUP INC |
| 3rd row | AMERICAN AIRLINES GROUP INC |
| 4th row | AMERICAN AIRLINES GROUP INC |
| 5th row | AMERICAN AIRLINES GROUP INC |
Common Values
| Value | Count | Frequency (%) |
| PG&E CORP | 138 | 0.5% |
| EDISON INTERNATIONAL | 124 | 0.4% |
| SCHWAB (CHARLES) CORP | 118 | 0.4% |
| CONOCOPHILLIPS | 112 | 0.4% |
| FORD MOTOR CO | 111 | 0.4% |
| CMS ENERGY CORP | 109 | 0.4% |
| MICRON TECHNOLOGY INC | 108 | 0.4% |
| AMERICAN INTERNATIONAL GROUP | 107 | 0.4% |
| EXELON CORP | 106 | 0.4% |
| WILLIAMS COS INC | 106 | 0.4% |
| Other values (376) | 27814 |
Length
| Value | Count | Frequency (%) |
| inc | 12909 | 16.0% |
| corp | 7891 | 9.8% |
| co | 3839 | 4.7% |
| 1734 | 2.1% | |
| energy | 1348 | 1.7% |
| group | 1311 | 1.6% |
| plc | 865 | 1.1% |
| financial | 728 | 0.9% |
| intl | 685 | 0.8% |
| technologies | 675 | 0.8% |
| Other values (546) | 48917 |
Most occurring characters
| Value | Count | Frequency (%) |
| 52222 | ||
| C | 44637 | 9.2% |
| N | 41102 | 8.4% |
| O | 39829 | 8.2% |
| E | 37988 | 7.8% |
| I | 36702 | 7.5% |
| R | 36678 | 7.5% |
| A | 29244 | 6.0% |
| S | 22407 | 4.6% |
| L | 22142 | 4.5% |
| Other values (26) | 124074 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 428145 | |
| Space Separator | 52222 | 10.7% |
| Other Punctuation | 2710 | 0.6% |
| Dash Punctuation | 1435 | 0.3% |
| Open Punctuation | 1150 | 0.2% |
| Close Punctuation | 1150 | 0.2% |
| Decimal Number | 213 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 44637 | |
| N | 41102 | |
| O | 39829 | |
| E | 37988 | 8.9% |
| I | 36702 | 8.6% |
| R | 36678 | 8.6% |
| A | 29244 | 6.8% |
| S | 22407 | 5.2% |
| L | 22142 | 5.2% |
| T | 21915 | 5.1% |
| Other values (16) | 95501 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 2053 | |
| ' | 290 | 10.7% |
| . | 267 | 9.9% |
| / | 100 | 3.7% |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 191 | |
| 5 | 22 | 10.3% |
Space Separator
| Value | Count | Frequency (%) |
| 52222 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1435 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1150 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1150 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 428145 | |
| Common | 58880 | 12.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 44637 | |
| N | 41102 | |
| O | 39829 | |
| E | 37988 | 8.9% |
| I | 36702 | 8.6% |
| R | 36678 | 8.6% |
| A | 29244 | 6.8% |
| S | 22407 | 5.2% |
| L | 22142 | 5.2% |
| T | 21915 | 5.1% |
| Other values (16) | 95501 |
Common
| Value | Count | Frequency (%) |
| 52222 | ||
| & | 2053 | 3.5% |
| - | 1435 | 2.4% |
| ( | 1150 | 2.0% |
| ) | 1150 | 2.0% |
| ' | 290 | 0.5% |
| . | 267 | 0.5% |
| 3 | 191 | 0.3% |
| / | 100 | 0.2% |
| 5 | 22 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 487025 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 52222 | ||
| C | 44637 | 9.2% |
| N | 41102 | 8.4% |
| O | 39829 | 8.2% |
| E | 37988 | 7.8% |
| I | 36702 | 7.5% |
| R | 36678 | 7.5% |
| A | 29244 | 6.0% |
| S | 22407 | 4.6% |
| L | 22142 | 4.5% |
| Other values (26) | 124074 |
CEOANN
Categorical
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 24685 |
| Missing (%) | 85.3% |
| Memory size | 226.3 KiB |
| CEO |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 12804 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CEO |
|---|---|
| 2nd row | CEO |
| 3rd row | CEO |
| 4th row | CEO |
| 5th row | CEO |
Common Values
| Value | Count | Frequency (%) |
| CEO | 4268 | 14.7% |
| (Missing) | 24685 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| ceo | 4268 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 4268 | |
| E | 4268 | |
| O | 4268 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 12804 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 4268 | |
| E | 4268 | |
| O | 4268 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 12804 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 4268 | |
| E | 4268 | |
| O | 4268 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12804 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| C | 4268 | |
| E | 4268 | |
| O | 4268 |
SALARY
Real number (ℝ)
| Distinct | 14776 |
|---|---|
| Distinct (%) | 51.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 451.39446 |
| Minimum | -0.0001 |
|---|---|
| Maximum | 6765 |
| Zeros | 66 |
| Zeros (%) | 0.2% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 226.3 KiB |
Quantile statistics
| Minimum | -0.0001 |
|---|---|
| 5-th percentile | 143.3966 |
| Q1 | 255.221 |
| median | 375 |
| Q3 | 553 |
| 95-th percentile | 1000 |
| Maximum | 6765 |
| Range | 6765.0001 |
| Interquartile range (IQR) | 297.779 |
Descriptive statistics
| Standard deviation | 314.85195 |
|---|---|
| Coefficient of variation (CV) | 0.69750956 |
| Kurtosis | 33.500736 |
| Mean | 451.39446 |
| Median Absolute Deviation (MAD) | 137.5 |
| Skewness | 3.6453475 |
| Sum | 13069224 |
| Variance | 99131.752 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 300 | 385 | 1.3% |
| 400 | 318 | 1.1% |
| 1000 | 302 | 1.0% |
| 500 | 293 | 1.0% |
| 600 | 263 | 0.9% |
| 450 | 244 | 0.8% |
| 350 | 223 | 0.8% |
| 250 | 207 | 0.7% |
| 200 | 189 | 0.7% |
| 800 | 152 | 0.5% |
| Other values (14766) | 26377 |
| Value | Count | Frequency (%) |
| -0.0001 | 1 | < 0.1% |
| 0 | 66 | |
| 0.001 | 30 | |
| 0.827 | 1 | < 0.1% |
| 1.923 | 1 | < 0.1% |
| 2.02 | 1 | < 0.1% |
| 2.223 | 2 | < 0.1% |
| 2.363 | 1 | < 0.1% |
| 2.418 | 1 | < 0.1% |
| 4.615 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 6765 | 1 | |
| 5806.651 | 1 | |
| 5773.077 | 1 | |
| 5306.651 | 1 | |
| 5294.095 | 1 | |
| 4973.073 | 1 | |
| 4600 | 1 | |
| 4476.101 | 1 | |
| 4395.697 | 1 | |
| 4309.092 | 1 |
BONUS
Real number (ℝ)
| Distinct | 14343 |
|---|---|
| Distinct (%) | 49.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 559.16719 |
| Minimum | 0 |
|---|---|
| Maximum | 43511.534 |
| Zeros | 2849 |
| Zeros (%) | 9.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 226.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 111.665 |
| median | 260.825 |
| Q3 | 557.376 |
| 95-th percentile | 1978.92 |
| Maximum | 43511.534 |
| Range | 43511.534 |
| Interquartile range (IQR) | 445.711 |
Descriptive statistics
| Standard deviation | 1195.9494 |
|---|---|
| Coefficient of variation (CV) | 2.1388047 |
| Kurtosis | 164.18055 |
| Mean | 559.16719 |
| Median Absolute Deviation (MAD) | 189.175 |
| Skewness | 9.5003975 |
| Sum | 16189568 |
| Variance | 1430295 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2849 | 9.8% |
| 300 | 272 | 0.9% |
| 500 | 229 | 0.8% |
| 200 | 225 | 0.8% |
| 250 | 205 | 0.7% |
| 100 | 204 | 0.7% |
| 400 | 203 | 0.7% |
| 350 | 196 | 0.7% |
| 150 | 193 | 0.7% |
| 600 | 161 | 0.6% |
| Other values (14333) | 24216 |
| Value | Count | Frequency (%) |
| 0 | 2849 | |
| 0.026 | 1 | < 0.1% |
| 0.2 | 1 | < 0.1% |
| 0.25 | 2 | < 0.1% |
| 0.3 | 2 | < 0.1% |
| 0.4 | 1 | < 0.1% |
| 0.428 | 1 | < 0.1% |
| 0.5 | 1 | < 0.1% |
| 0.7 | 11 | < 0.1% |
| 0.759 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 43511.534 | 1 | |
| 33000 | 1 | |
| 29000 | 1 | |
| 26640.502 | 1 | |
| 26000 | 1 | |
| 23618.156 | 1 | |
| 22900.821 | 1 | |
| 22000 | 1 | |
| 21519.6 | 1 | |
| 20272.096 | 1 |
PENSION_CHG
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 28953 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 226.3 KiB |
TOTAL_SEC
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 28953 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 226.3 KiB |
TOTAL_CURR
Real number (ℝ)
| Distinct | 22315 |
|---|---|
| Distinct (%) | 77.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1010.5616 |
| Minimum | -0.0001 |
|---|---|
| Maximum | 43511.535 |
| Zeros | 52 |
| Zeros (%) | 0.2% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 226.3 KiB |
Quantile statistics
| Minimum | -0.0001 |
|---|---|
| 5-th percentile | 203.0792 |
| Q1 | 407.394 |
| median | 653.533 |
| Q3 | 1109.225 |
| 95-th percentile | 2845.833 |
| Maximum | 43511.535 |
| Range | 43511.535 |
| Interquartile range (IQR) | 701.831 |
Descriptive statistics
| Standard deviation | 1361.38 |
|---|---|
| Coefficient of variation (CV) | 1.3471519 |
| Kurtosis | 110.62735 |
| Mean | 1010.5616 |
| Median Absolute Deviation (MAD) | 302.7 |
| Skewness | 7.6558172 |
| Sum | 29258791 |
| Variance | 1853355.6 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 500 | 71 | 0.2% |
| 1000 | 66 | 0.2% |
| 550 | 66 | 0.2% |
| 800 | 66 | 0.2% |
| 600 | 64 | 0.2% |
| 450 | 64 | 0.2% |
| 750 | 62 | 0.2% |
| 700 | 62 | 0.2% |
| 0 | 52 | 0.2% |
| 400 | 48 | 0.2% |
| Other values (22305) | 28332 |
| Value | Count | Frequency (%) |
| -0.0001 | 1 | < 0.1% |
| 0 | 52 | |
| 0.001 | 19 | 0.1% |
| 1.631 | 2 | < 0.1% |
| 1.724 | 1 | < 0.1% |
| 2.223 | 2 | < 0.1% |
| 2.363 | 1 | < 0.1% |
| 2.418 | 1 | < 0.1% |
| 4.615 | 1 | < 0.1% |
| 6.231 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 43511.535 | 1 | |
| 34000 | 1 | |
| 30000 | 1 | |
| 27998.838 | 1 | |
| 27000 | 1 | |
| 23957.5 | 1 | |
| 23550.821 | 1 | |
| 22519.6 | 1 | |
| 22450.137 | 1 | |
| 21906 | 1 |
CHG_CTRL_PYMT
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 28953 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 226.3 KiB |
AGE
Real number (ℝ)
| Distinct | 60 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 18708 |
| Missing (%) | 64.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.363202 |
| Minimum | 28 |
|---|---|
| Maximum | 87 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 226.3 KiB |
Quantile statistics
| Minimum | 28 |
|---|---|
| 5-th percentile | 42 |
| Q1 | 49 |
| median | 55 |
| Q3 | 59 |
| 95-th percentile | 66 |
| Maximum | 87 |
| Range | 59 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 7.7443882 |
|---|---|
| Coefficient of variation (CV) | 0.14245644 |
| Kurtosis | 0.55546124 |
| Mean | 54.363202 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.15507555 |
| Sum | 556951 |
| Variance | 59.975549 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 56 | 544 | 1.9% |
| 54 | 543 | 1.9% |
| 55 | 538 | 1.9% |
| 58 | 535 | 1.8% |
| 57 | 532 | 1.8% |
| 52 | 511 | 1.8% |
| 59 | 506 | 1.7% |
| 53 | 501 | 1.7% |
| 51 | 467 | 1.6% |
| 60 | 457 | 1.6% |
| Other values (50) | 5111 | 17.7% |
| (Missing) | 18708 |
| Value | Count | Frequency (%) |
| 28 | 1 | < 0.1% |
| 29 | 2 | < 0.1% |
| 30 | 2 | < 0.1% |
| 31 | 6 | < 0.1% |
| 32 | 6 | < 0.1% |
| 33 | 7 | < 0.1% |
| 34 | 18 | |
| 35 | 20 | |
| 36 | 29 | |
| 37 | 44 |
| Value | Count | Frequency (%) |
| 87 | 1 | < 0.1% |
| 86 | 2 | < 0.1% |
| 85 | 2 | < 0.1% |
| 84 | 3 | < 0.1% |
| 83 | 5 | < 0.1% |
| 82 | 7 | |
| 81 | 12 | |
| 80 | 14 | |
| 79 | 14 | |
| 78 | 15 |
EXECRANKANN
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 7094 |
| Missing (%) | 24.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.1344069 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 226.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.564356 |
|---|---|
| Coefficient of variation (CV) | 0.49909157 |
| Kurtosis | -0.70116284 |
| Mean | 3.1344069 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.25205962 |
| Sum | 68515 |
| Variance | 2.4472098 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 4275 | |
| 2 | 4249 | |
| 3 | 4131 | |
| 4 | 4089 | |
| 5 | 4019 | |
| 6 | 860 | 3.0% |
| 7 | 177 | 0.6% |
| 8 | 41 | 0.1% |
| 9 | 13 | < 0.1% |
| 11 | 2 | < 0.1% |
| Other values (2) | 3 | < 0.1% |
| (Missing) | 7094 |
| Value | Count | Frequency (%) |
| 1 | 4275 | |
| 2 | 4249 | |
| 3 | 4131 | |
| 4 | 4089 | |
| 5 | 4019 | |
| 6 | 860 | 3.0% |
| 7 | 177 | 0.6% |
| 8 | 41 | 0.1% |
| 9 | 13 | < 0.1% |
| 10 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 12 | 1 | < 0.1% |
| 11 | 2 | < 0.1% |
| 10 | 2 | < 0.1% |
| 9 | 13 | < 0.1% |
| 8 | 41 | 0.1% |
| 7 | 177 | 0.6% |
| 6 | 860 | 3.0% |
| 5 | 4019 | |
| 4 | 4089 | |
| 3 | 4131 |
TDC1
Real number (ℝ)
MISSING  SKEWED 
| Distinct | 23856 |
|---|---|
| Distinct (%) | 98.8% |
| Missing | 4801 |
| Missing (%) | 16.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3348.4942 |
| Minimum | -0.0001 |
|---|---|
| Maximum | 600347.35 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 226.3 KiB |
Quantile statistics
| Minimum | -0.0001 |
|---|---|
| 5-th percentile | 311.12595 |
| Q1 | 803.44075 |
| median | 1599.531 |
| Q3 | 3394.6737 |
| 95-th percentile | 11447.112 |
| Maximum | 600347.35 |
| Range | 600347.35 |
| Interquartile range (IQR) | 2591.233 |
Descriptive statistics
| Standard deviation | 7718.9535 |
|---|---|
| Coefficient of variation (CV) | 2.3052014 |
| Kurtosis | 1616.7014 |
| Mean | 3348.4942 |
| Median Absolute Deviation (MAD) | 993.442 |
| Skewness | 26.793197 |
| Sum | 80872832 |
| Variance | 59582243 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.001 | 11 | < 0.1% |
| 100 | 8 | < 0.1% |
| 122.5 | 6 | < 0.1% |
| 108.2 | 5 | < 0.1% |
| 314 | 5 | < 0.1% |
| 300 | 4 | < 0.1% |
| 3716.024 | 4 | < 0.1% |
| 81.84 | 4 | < 0.1% |
| 250 | 4 | < 0.1% |
| 200 | 4 | < 0.1% |
| Other values (23846) | 24097 | |
| (Missing) | 4801 | 16.6% |
| Value | Count | Frequency (%) |
| -0.0001 | 1 | < 0.1% |
| 0 | 3 | < 0.1% |
| 0.001 | 11 | |
| 1.32 | 1 | < 0.1% |
| 4.615 | 1 | < 0.1% |
| 8.654 | 1 | < 0.1% |
| 11.336 | 1 | < 0.1% |
| 20 | 2 | < 0.1% |
| 20.796 | 1 | < 0.1% |
| 21.923 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 600347.351 | 1 | |
| 230033.652 | 1 | |
| 204489.424 | 1 | |
| 202185.14 | 1 | |
| 176279.53 | 1 | |
| 159309.275 | 1 | |
| 147586.945 | 1 | |
| 140918.266 | 1 | |
| 137669.87 | 1 | |
| 137669.317 | 1 |
ALLOTHTOT
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 18645 |
|---|---|
| Distinct (%) | 64.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 114.0286 |
| Minimum | 0 |
|---|---|
| Maximum | 95195.5 |
| Zeros | 2466 |
| Zeros (%) | 8.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 226.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 6 |
| median | 17.364 |
| Q3 | 50.864 |
| 95-th percentile | 270.7228 |
| Maximum | 95195.5 |
| Range | 95195.5 |
| Interquartile range (IQR) | 44.864 |
Descriptive statistics
| Standard deviation | 998.75688 |
|---|---|
| Coefficient of variation (CV) | 8.7588281 |
| Kurtosis | 3369.1492 |
| Mean | 114.0286 |
| Median Absolute Deviation (MAD) | 14.377 |
| Skewness | 45.882041 |
| Sum | 3301470 |
| Variance | 997515.31 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2466 | 8.5% |
| 1.5 | 218 | 0.8% |
| 6 | 187 | 0.6% |
| 8 | 148 | 0.5% |
| 4.8 | 110 | 0.4% |
| 10 | 88 | 0.3% |
| 9 | 87 | 0.3% |
| 5 | 82 | 0.3% |
| 5.1 | 78 | 0.3% |
| 7.5 | 76 | 0.3% |
| Other values (18635) | 25413 |
| Value | Count | Frequency (%) |
| 0 | 2466 | |
| 0.003 | 3 | < 0.1% |
| 0.025 | 1 | < 0.1% |
| 0.03 | 1 | < 0.1% |
| 0.034 | 1 | < 0.1% |
| 0.039 | 1 | < 0.1% |
| 0.066 | 1 | < 0.1% |
| 0.069 | 2 | < 0.1% |
| 0.073 | 1 | < 0.1% |
| 0.074 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 95195.5 | 1 | |
| 48922.949 | 1 | |
| 40484.594 | 1 | |
| 36479.425 | 1 | |
| 33688.97 | 1 | |
| 33684.634 | 1 | |
| 28978.755 | 1 | |
| 22706.15 | 1 | |
| 22006.1 | 1 | |
| 21859.386 | 1 |
ALLOTHPD
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 2033 |
|---|---|
| Distinct (%) | 7.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 49.674424 |
| Minimum | 0 |
|---|---|
| Maximum | 95107.134 |
| Zeros | 26385 |
| Zeros (%) | 91.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 226.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 27.2476 |
| Maximum | 95107.134 |
| Range | 95107.134 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 879.16354 |
|---|---|
| Coefficient of variation (CV) | 17.698515 |
| Kurtosis | 5444.9111 |
| Mean | 49.674424 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 61.418234 |
| Sum | 1438223.6 |
| Variance | 772928.52 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 26385 | |
| 6 | 21 | 0.1% |
| 50 | 17 | 0.1% |
| 100 | 16 | 0.1% |
| 26 | 16 | 0.1% |
| 1 | 15 | 0.1% |
| 12.5 | 14 | < 0.1% |
| 1.5 | 13 | < 0.1% |
| 8.4 | 12 | < 0.1% |
| 12 | 12 | < 0.1% |
| Other values (2023) | 2432 | 8.4% |
| Value | Count | Frequency (%) |
| 0 | 26385 | |
| 0.05 | 2 | < 0.1% |
| 0.066 | 1 | < 0.1% |
| 0.1 | 1 | < 0.1% |
| 0.115 | 1 | < 0.1% |
| 0.128 | 1 | < 0.1% |
| 0.137 | 1 | < 0.1% |
| 0.15 | 2 | < 0.1% |
| 0.153 | 1 | < 0.1% |
| 0.18 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 95107.134 | 1 | |
| 48917.997 | 1 | |
| 40484.594 | 1 | |
| 33688.97 | 1 | |
| 33684.634 | 1 | |
| 28960.132 | 1 | |
| 21859.386 | 1 | |
| 17687.141 | 1 | |
| 17067.987 | 1 | |
| 16448.276 | 1 |
SAL_PCT
Real number (ℝ)
MISSING  SKEWED  ZEROS 
| Distinct | 12653 |
|---|---|
| Distinct (%) | 53.5% |
| Missing | 5288 |
| Missing (%) | 18.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.274287 |
| Minimum | -100 |
|---|---|
| Maximum | 25897.582 |
| Zeros | 2347 |
| Zeros (%) | 8.1% |
| Negative | 1250 |
| Negative (%) | 4.3% |
| Memory size | 226.3 KiB |
Quantile statistics
| Minimum | -100 |
|---|---|
| 5-th percentile | -0.1848 |
| Q1 | 3.392 |
| median | 6.897 |
| Q3 | 14.016 |
| 95-th percentile | 45.8126 |
| Maximum | 25897.582 |
| Range | 25997.582 |
| Interquartile range (IQR) | 10.624 |
Descriptive statistics
| Standard deviation | 293.56048 |
|---|---|
| Coefficient of variation (CV) | 12.093475 |
| Kurtosis | 5313.7345 |
| Mean | 24.274287 |
| Median Absolute Deviation (MAD) | 4.862 |
| Skewness | 64.951143 |
| Sum | 574451.01 |
| Variance | 86177.758 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2347 | 8.1% |
| 5 | 156 | 0.5% |
| 10 | 140 | 0.5% |
| 4 | 107 | 0.4% |
| 11.111 | 106 | 0.4% |
| 5.263 | 86 | 0.3% |
| 12.5 | 75 | 0.3% |
| 7.143 | 74 | 0.3% |
| 6.667 | 74 | 0.3% |
| 14.286 | 71 | 0.2% |
| Other values (12643) | 20429 | |
| (Missing) | 5288 | 18.3% |
| Value | Count | Frequency (%) |
| -100 | 11 | |
| -99.999 | 2 | < 0.1% |
| -99.998 | 2 | < 0.1% |
| -98.485 | 1 | < 0.1% |
| -96.217 | 1 | < 0.1% |
| -94.494 | 1 | < 0.1% |
| -93.675 | 1 | < 0.1% |
| -92.334 | 1 | < 0.1% |
| -91.923 | 1 | < 0.1% |
| -91.912 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 25897.582 | 1 | |
| 25890.099 | 1 | |
| 12650.494 | 1 | |
| 8275.295 | 1 | |
| 7100.461 | 1 | |
| 6736.213 | 1 | |
| 5600 | 1 | |
| 5386.542 | 1 | |
| 4410.703 | 1 | |
| 4098.794 | 1 |
TOTAL_CURR_PCT
Real number (ℝ)
MISSING  SKEWED  ZEROS 
| Distinct | 19458 |
|---|---|
| Distinct (%) | 82.2% |
| Missing | 5283 |
| Missing (%) | 18.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.972142 |
| Minimum | -100 |
|---|---|
| Maximum | 16361.776 |
| Zeros | 424 |
| Zeros (%) | 1.5% |
| Negative | 5778 |
| Negative (%) | 20.0% |
| Memory size | 226.3 KiB |
Quantile statistics
| Minimum | -100 |
|---|---|
| 5-th percentile | -33.85755 |
| Q1 | 0 |
| median | 11.0595 |
| Q3 | 29.39175 |
| 95-th percentile | 103.70755 |
| Maximum | 16361.776 |
| Range | 16461.776 |
| Interquartile range (IQR) | 29.39175 |
Descriptive statistics
| Standard deviation | 227.17823 |
|---|---|
| Coefficient of variation (CV) | 7.3349214 |
| Kurtosis | 2345.8265 |
| Mean | 30.972142 |
| Median Absolute Deviation (MAD) | 13.9405 |
| Skewness | 39.726591 |
| Sum | 733110.6 |
| Variance | 51609.947 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 424 | 1.5% |
| 10 | 30 | 0.1% |
| 7.143 | 26 | 0.1% |
| 5 | 23 | 0.1% |
| 8.333 | 22 | 0.1% |
| 11.111 | 20 | 0.1% |
| 16.667 | 20 | 0.1% |
| 9.091 | 19 | 0.1% |
| 14.286 | 19 | 0.1% |
| 20 | 19 | 0.1% |
| Other values (19448) | 23048 | |
| (Missing) | 5283 | 18.2% |
| Value | Count | Frequency (%) |
| -100 | 12 | |
| -99.999 | 1 | < 0.1% |
| -98.907 | 1 | < 0.1% |
| -98.035 | 1 | < 0.1% |
| -96.923 | 1 | < 0.1% |
| -96.4 | 1 | < 0.1% |
| -96.195 | 1 | < 0.1% |
| -95.117 | 1 | < 0.1% |
| -95.037 | 1 | < 0.1% |
| -94.975 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 16361.776 | 1 | |
| 15888.314 | 1 | |
| 7819.747 | 1 | |
| 6713.052 | 1 | |
| 6017.611 | 1 | |
| 5640.907 | 1 | |
| 5406.47 | 1 | |
| 5047.943 | 1 | |
| 4708.101 | 1 | |
| 4464.789 | 1 |
TOTAL_SEC_PCT
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 28953 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 226.3 KiB |
TDC1_PCT
Real number (ℝ)
MISSING  SKEWED 
| Distinct | 17364 |
|---|---|
| Distinct (%) | 94.5% |
| Missing | 10584 |
| Missing (%) | 36.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 57.279147 |
| Minimum | -100 |
|---|---|
| Maximum | 61584.348 |
| Zeros | 31 |
| Zeros (%) | 0.1% |
| Negative | 6646 |
| Negative (%) | 23.0% |
| Memory size | 226.3 KiB |
Quantile statistics
| Minimum | -100 |
|---|---|
| 5-th percentile | -62.4366 |
| Q1 | -14.179 |
| median | 12.496 |
| Q3 | 49.196 |
| 95-th percentile | 220.7852 |
| Maximum | 61584.348 |
| Range | 61684.348 |
| Interquartile range (IQR) | 63.375 |
Descriptive statistics
| Standard deviation | 622.8505 |
|---|---|
| Coefficient of variation (CV) | 10.873949 |
| Kurtosis | 5628.7641 |
| Mean | 57.279147 |
| Median Absolute Deviation (MAD) | 30.634 |
| Skewness | 64.956752 |
| Sum | 1052160.7 |
| Variance | 387942.75 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 31 | 0.1% |
| 18.205 | 5 | < 0.1% |
| -100 | 5 | < 0.1% |
| 2.491 | 4 | < 0.1% |
| 5.765 | 4 | < 0.1% |
| 12.607 | 3 | < 0.1% |
| 21.379 | 3 | < 0.1% |
| -5.905 | 3 | < 0.1% |
| -32.812 | 3 | < 0.1% |
| 19.62 | 3 | < 0.1% |
| Other values (17354) | 18305 | |
| (Missing) | 10584 |
| Value | Count | Frequency (%) |
| -100 | 5 | |
| -99.999 | 1 | < 0.1% |
| -99.976 | 1 | < 0.1% |
| -99.888 | 1 | < 0.1% |
| -99.842 | 1 | < 0.1% |
| -99.81 | 1 | < 0.1% |
| -99.088 | 1 | < 0.1% |
| -98.825 | 1 | < 0.1% |
| -98.81 | 1 | < 0.1% |
| -98.62 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 61584.348 | 1 | |
| 26917.081 | 1 | |
| 26044.747 | 1 | |
| 19328.696 | 1 | |
| 13753.536 | 1 | |
| 12836.159 | 1 | |
| 12066.569 | 1 | |
| 11154.725 | 1 | |
| 8152.02 | 1 | |
| 8138.907 | 1 |
COMMENT
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 1413 |
|---|---|
| Distinct (%) | 65.0% |
| Missing | 26778 |
| Missing (%) | 92.5% |
| Memory size | 226.3 KiB |
| *Excl. portion of bonus paid in restricted stock. | 109 |
|---|---|
| *May contain preliminary information. | 56 |
| *Excl. 50% of bonus paid in stock options. | 31 |
| *Excludes portion of bonus paid in restricted stock. | 26 |
| *Compensation also listed under USX-U.S. Steel. | 23 |
| Other values (1408) |
Length
| Max length | 235 |
|---|---|
| Median length | 181 |
| Mean length | 50.11954 |
| Min length | 12 |
Characters and Unicode
| Total characters | 109010 |
|---|---|
| Distinct characters | 77 |
| Distinct categories | 11 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 1223 ? |
|---|---|
| Unique (%) | 56.2% |
Sample
| 1st row | *1994 bonus has not been determined. |
|---|---|
| 2nd row | *1996 LTIP has not yet been determined. |
| 3rd row | *Includes $638,600 in consulting/severance payments and $73,684 in accrued vacation pay. |
| 4th row | Includes $1,156,981 in consulting/severance payments and $60,000 in accrued vacation pay. |
| 5th row | *Incl one additional pay period. |
Common Values
| Value | Count | Frequency (%) |
| *Excl. portion of bonus paid in restricted stock. | 109 | 0.4% |
| *May contain preliminary information. | 56 | 0.2% |
| *Excl. 50% of bonus paid in stock options. | 31 | 0.1% |
| *Excludes portion of bonus paid in restricted stock. | 26 | 0.1% |
| *Compensation also listed under USX-U.S. Steel. | 23 | 0.1% |
| *Excl. portion of bonus pd in restricted stock. | 21 | 0.1% |
| *Compensation also listed under Newmont Gold Co. | 14 | < 0.1% |
| *Incl one additional pay period. | 14 | < 0.1% |
| *Elected to forego salary & bonus for stock opt. grants. | 13 | < 0.1% |
| *Includes portion of bonus paid in options. | 13 | < 0.1% |
| Other values (1403) | 1855 | 6.4% |
| (Missing) | 26778 |
Length
| Value | Count | Frequency (%) |
| in | 887 | 5.4% |
| bonus | 788 | 4.8% |
| incl | 710 | 4.3% |
| of | 648 | 3.9% |
| paid | 514 | 3.1% |
| stock | 436 | 2.6% |
| excl | 434 | 2.6% |
| includes | 347 | 2.1% |
| restricted | 277 | 1.7% |
| to | 276 | 1.7% |
| Other values (2036) | 11160 |
Most occurring characters
| Value | Count | Frequency (%) |
| 14337 | 13.2% | |
| n | 7681 | 7.0% |
| e | 7166 | 6.6% |
| o | 6662 | 6.1% |
| i | 5552 | 5.1% |
| t | 5404 | 5.0% |
| s | 5172 | 4.7% |
| r | 4651 | 4.3% |
| a | 4459 | 4.1% |
| c | 4014 | 3.7% |
| Other values (67) | 43912 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 72303 | |
| Space Separator | 14337 | 13.2% |
| Decimal Number | 8864 | 8.1% |
| Other Punctuation | 8070 | 7.4% |
| Uppercase Letter | 3825 | 3.5% |
| Currency Symbol | 1248 | 1.1% |
| Dash Punctuation | 245 | 0.2% |
| Close Punctuation | 50 | < 0.1% |
| Open Punctuation | 50 | < 0.1% |
| Final Punctuation | 13 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 7681 | |
| e | 7166 | 9.9% |
| o | 6662 | 9.2% |
| i | 5552 | 7.7% |
| t | 5404 | 7.5% |
| s | 5172 | 7.2% |
| r | 4651 | 6.4% |
| a | 4459 | 6.2% |
| c | 4014 | 5.6% |
| l | 3478 | 4.8% |
| Other values (16) | 18064 |
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 1169 | |
| E | 617 | |
| C | 330 | 8.6% |
| S | 246 | 6.4% |
| M | 216 | 5.6% |
| P | 166 | 4.3% |
| T | 155 | 4.1% |
| A | 134 | 3.5% |
| R | 123 | 3.2% |
| O | 106 | 2.8% |
| Other values (15) | 563 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 2592 | |
| 1 | 1031 | 11.6% |
| 5 | 848 | 9.6% |
| 2 | 827 | 9.3% |
| 9 | 731 | 8.2% |
| 3 | 688 | 7.8% |
| 4 | 595 | 6.7% |
| 8 | 523 | 5.9% |
| 7 | 518 | 5.8% |
| 6 | 511 | 5.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 3845 | |
| * | 2245 | |
| , | 1422 | 17.6% |
| / | 255 | 3.2% |
| & | 147 | 1.8% |
| ' | 76 | 0.9% |
| % | 68 | 0.8% |
| ; | 12 | 0.1% |
Math Symbol
| Value | Count | Frequency (%) |
| = | 4 | |
| + | 1 | 20.0% |
Space Separator
| Value | Count | Frequency (%) |
| 14337 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 1248 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 245 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 50 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 50 |
Final Punctuation
| Value | Count | Frequency (%) |
| ’ | 13 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 76128 | |
| Common | 32882 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 7681 | 10.1% |
| e | 7166 | 9.4% |
| o | 6662 | 8.8% |
| i | 5552 | 7.3% |
| t | 5404 | 7.1% |
| s | 5172 | 6.8% |
| r | 4651 | 6.1% |
| a | 4459 | 5.9% |
| c | 4014 | 5.3% |
| l | 3478 | 4.6% |
| Other values (41) | 21889 |
Common
| Value | Count | Frequency (%) |
| 14337 | ||
| . | 3845 | 11.7% |
| 0 | 2592 | 7.9% |
| * | 2245 | 6.8% |
| , | 1422 | 4.3% |
| $ | 1248 | 3.8% |
| 1 | 1031 | 3.1% |
| 5 | 848 | 2.6% |
| 2 | 827 | 2.5% |
| 9 | 731 | 2.2% |
| Other values (16) | 3756 | 11.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 108997 | |
| Punctuation | 13 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 14337 | 13.2% | |
| n | 7681 | 7.0% |
| e | 7166 | 6.6% |
| o | 6662 | 6.1% |
| i | 5552 | 5.1% |
| t | 5404 | 5.0% |
| s | 5172 | 4.7% |
| r | 4651 | 4.3% |
| a | 4459 | 4.1% |
| c | 4014 | 3.7% |
| Other values (66) | 43899 |
Punctuation
| Value | Count | Frequency (%) |
| ’ | 13 |
GVKEY
Real number (ℝ)
| Distinct | 386 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17473.837 |
| Minimum | 1045 |
|---|---|
| Maximum | 260774 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 226.3 KiB |
Quantile statistics
| Minimum | 1045 |
|---|---|
| 5-th percentile | 1678 |
| Q1 | 4510 |
| median | 8099 |
| Q3 | 14418 |
| 95-th percentile | 65609 |
| Maximum | 260774 |
| Range | 259729 |
| Interquartile range (IQR) | 9908 |
Descriptive statistics
| Standard deviation | 28499.711 |
|---|---|
| Coefficient of variation (CV) | 1.6309934 |
| Kurtosis | 13.215268 |
| Mean | 17473.837 |
| Median Absolute Deviation (MAD) | 4042 |
| Skewness | 3.4688056 |
| Sum | 5.0591999 × 108 |
| Variance | 8.1223355 × 108 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 8264 | 138 | 0.5% |
| 9846 | 124 | 0.4% |
| 13988 | 118 | 0.4% |
| 8549 | 112 | 0.4% |
| 4839 | 111 | 0.4% |
| 3439 | 109 | 0.4% |
| 7343 | 108 | 0.4% |
| 1487 | 107 | 0.4% |
| 8539 | 106 | 0.4% |
| 11506 | 106 | 0.4% |
| Other values (376) | 27814 |
| Value | Count | Frequency (%) |
| 1045 | 91 | |
| 1075 | 89 | |
| 1078 | 90 | |
| 1161 | 95 | |
| 1209 | 97 | |
| 1230 | 89 | |
| 1300 | 89 | |
| 1327 | 58 | |
| 1380 | 84 | |
| 1440 | 89 |
| Value | Count | Frequency (%) |
| 260774 | 20 | |
| 165993 | 15 | |
| 164708 | 15 | |
| 160329 | 14 | |
| 155394 | 22 | |
| 150937 | 26 | |
| 149337 | 15 | |
| 149070 | 22 | |
| 145977 | 25 | |
| 145701 | 33 |
EXECID
Real number (ℝ)
| Distinct | 5084 |
|---|---|
| Distinct (%) | 17.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12805.586 |
| Minimum | 3 |
|---|---|
| Maximum | 34976 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 226.3 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 717 |
| Q1 | 3661 |
| median | 12604 |
| Q3 | 20823 |
| 95-th percentile | 27633 |
| Maximum | 34976 |
| Range | 34973 |
| Interquartile range (IQR) | 17162 |
Descriptive statistics
| Standard deviation | 9132.5122 |
|---|---|
| Coefficient of variation (CV) | 0.71316629 |
| Kurtosis | -1.2405848 |
| Mean | 12805.586 |
| Median Absolute Deviation (MAD) | 8600 |
| Skewness | 0.20307487 |
| Sum | 3.7076013 × 108 |
| Variance | 83402779 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3765 | 16 | 0.1% |
| 5669 | 15 | 0.1% |
| 116 | 15 | 0.1% |
| 3434 | 14 | < 0.1% |
| 4228 | 14 | < 0.1% |
| 1030 | 14 | < 0.1% |
| 5820 | 14 | < 0.1% |
| 125 | 14 | < 0.1% |
| 9752 | 14 | < 0.1% |
| 9753 | 14 | < 0.1% |
| Other values (5074) | 28809 |
| Value | Count | Frequency (%) |
| 3 | 7 | |
| 7 | 10 | |
| 8 | 12 | |
| 10 | 6 | |
| 13 | 14 | |
| 15 | 10 | |
| 26 | 11 | |
| 28 | 3 | < 0.1% |
| 36 | 4 | < 0.1% |
| 39 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 34976 | 2 | < 0.1% |
| 34974 | 1 | < 0.1% |
| 34965 | 2 | < 0.1% |
| 34964 | 2 | < 0.1% |
| 34963 | 5 | |
| 34897 | 3 | |
| 34896 | 4 | |
| 34895 | 4 | |
| 34406 | 5 | |
| 34404 | 2 | < 0.1% |
YEAR
Real number (ℝ)
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1999.008 |
| Minimum | 1992 |
|---|---|
| Maximum | 2005 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 226.3 KiB |
Quantile statistics
| Minimum | 1992 |
|---|---|
| 5-th percentile | 1993 |
| Q1 | 1996 |
| median | 1999 |
| Q3 | 2002 |
| 95-th percentile | 2005 |
| Maximum | 2005 |
| Range | 13 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.8733942 |
|---|---|
| Coefficient of variation (CV) | 0.0019376582 |
| Kurtosis | -1.1161784 |
| Mean | 1999.008 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.16344235 |
| Sum | 57877279 |
| Variance | 15.003183 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2003 | 2458 | 8.5% |
| 2002 | 2410 | 8.3% |
| 2001 | 2344 | 8.1% |
| 2004 | 2315 | 8.0% |
| 2000 | 2304 | 8.0% |
| 1999 | 2275 | 7.9% |
| 1998 | 2188 | 7.6% |
| 2005 | 2075 | 7.2% |
| 1997 | 2027 | 7.0% |
| 1996 | 1900 | 6.6% |
| Other values (4) | 6657 |
| Value | Count | Frequency (%) |
| 1992 | 1399 | |
| 1993 | 1653 | |
| 1994 | 1774 | |
| 1995 | 1831 | |
| 1996 | 1900 | |
| 1997 | 2027 | |
| 1998 | 2188 | |
| 1999 | 2275 | |
| 2000 | 2304 | |
| 2001 | 2344 |
| Value | Count | Frequency (%) |
| 2005 | 2075 | |
| 2004 | 2315 | |
| 2003 | 2458 | |
| 2002 | 2410 | |
| 2001 | 2344 | |
| 2000 | 2304 | |
| 1999 | 2275 | |
| 1998 | 2188 | |
| 1997 | 2027 | |
| 1996 | 1900 |
BECAMECEO
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 559 |
|---|---|
| Distinct (%) | 7.0% |
| Missing | 20979 |
| Missing (%) | 72.5% |
| Memory size | 226.3 KiB |
| 2000-01-01 | 197 |
|---|---|
| 2001-01-01 | 143 |
| 1998-01-01 | 140 |
| 1994-01-01 | 113 |
| 1990-01-01 | 109 |
| Other values (554) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 79740 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 12 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | 1985-03-01 |
|---|---|
| 2nd row | 1998-05-20 |
| 3rd row | 1985-03-01 |
| 4th row | 1998-05-20 |
| 5th row | 1985-03-01 |
Common Values
| Value | Count | Frequency (%) |
| 2000-01-01 | 197 | 0.7% |
| 2001-01-01 | 143 | 0.5% |
| 1998-01-01 | 140 | 0.5% |
| 1994-01-01 | 113 | 0.4% |
| 1990-01-01 | 109 | 0.4% |
| 1993-01-01 | 101 | 0.3% |
| 1999-01-01 | 98 | 0.3% |
| 1997-01-01 | 91 | 0.3% |
| 2001-02-01 | 82 | 0.3% |
| 2002-01-01 | 80 | 0.3% |
| Other values (549) | 6820 | 23.6% |
| (Missing) | 20979 |
Length
| Value | Count | Frequency (%) |
| 2000-01-01 | 197 | 2.5% |
| 2001-01-01 | 143 | 1.8% |
| 1998-01-01 | 140 | 1.8% |
| 1994-01-01 | 113 | 1.4% |
| 1990-01-01 | 109 | 1.4% |
| 1993-01-01 | 101 | 1.3% |
| 1999-01-01 | 98 | 1.2% |
| 1997-01-01 | 91 | 1.1% |
| 2001-02-01 | 82 | 1.0% |
| 2002-01-01 | 80 | 1.0% |
| Other values (549) | 6820 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 21186 | |
| 1 | 17139 | |
| - | 15948 | |
| 9 | 9019 | |
| 2 | 5809 | 7.3% |
| 8 | 2266 | 2.8% |
| 7 | 2048 | 2.6% |
| 5 | 1826 | 2.3% |
| 4 | 1556 | 2.0% |
| 3 | 1535 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 63792 | |
| Dash Punctuation | 15948 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 21186 | |
| 1 | 17139 | |
| 9 | 9019 | |
| 2 | 5809 | 9.1% |
| 8 | 2266 | 3.6% |
| 7 | 2048 | 3.2% |
| 5 | 1826 | 2.9% |
| 4 | 1556 | 2.4% |
| 3 | 1535 | 2.4% |
| 6 | 1408 | 2.2% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 15948 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 79740 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 21186 | |
| 1 | 17139 | |
| - | 15948 | |
| 9 | 9019 | |
| 2 | 5809 | 7.3% |
| 8 | 2266 | 2.8% |
| 7 | 2048 | 2.6% |
| 5 | 1826 | 2.3% |
| 4 | 1556 | 2.0% |
| 3 | 1535 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 79740 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 21186 | |
| 1 | 17139 | |
| - | 15948 | |
| 9 | 9019 | |
| 2 | 5809 | 7.3% |
| 8 | 2266 | 2.8% |
| 7 | 2048 | 2.6% |
| 5 | 1826 | 2.3% |
| 4 | 1556 | 2.0% |
| 3 | 1535 | 1.9% |
JOINED_CO
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 564 |
|---|---|
| Distinct (%) | 5.9% |
| Missing | 19336 |
| Missing (%) | 66.8% |
| Memory size | 226.3 KiB |
| 1979-01-01 | 195 |
|---|---|
| 1976-01-01 | 162 |
| 1984-01-01 | 147 |
| 1975-01-01 | 139 |
| 1963-01-01 | 139 |
| Other values (559) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 96170 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 44 ? |
|---|---|
| Unique (%) | 0.5% |
Sample
| 1st row | 1973-04-01 |
|---|---|
| 2nd row | 1973-04-01 |
| 3rd row | 1973-04-01 |
| 4th row | 1973-04-01 |
| 5th row | 1973-04-01 |
Common Values
| Value | Count | Frequency (%) |
| 1979-01-01 | 195 | 0.7% |
| 1976-01-01 | 162 | 0.6% |
| 1984-01-01 | 147 | 0.5% |
| 1975-01-01 | 139 | 0.5% |
| 1963-01-01 | 139 | 0.5% |
| 1982-01-01 | 139 | 0.5% |
| 1969-01-01 | 137 | 0.5% |
| 1966-01-01 | 135 | 0.5% |
| 1983-01-01 | 132 | 0.5% |
| 1971-01-01 | 131 | 0.5% |
| Other values (554) | 8161 | |
| (Missing) | 19336 |
Length
| Value | Count | Frequency (%) |
| 1979-01-01 | 195 | 2.0% |
| 1976-01-01 | 162 | 1.7% |
| 1984-01-01 | 147 | 1.5% |
| 1975-01-01 | 139 | 1.4% |
| 1963-01-01 | 139 | 1.4% |
| 1982-01-01 | 139 | 1.4% |
| 1969-01-01 | 137 | 1.4% |
| 1966-01-01 | 135 | 1.4% |
| 1983-01-01 | 132 | 1.4% |
| 1971-01-01 | 131 | 1.4% |
| Other values (554) | 8161 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 24555 | |
| 0 | 21635 | |
| - | 19234 | |
| 9 | 13214 | |
| 2 | 3614 | 3.8% |
| 8 | 3119 | 3.2% |
| 6 | 2830 | 2.9% |
| 7 | 2789 | 2.9% |
| 5 | 1822 | 1.9% |
| 4 | 1689 | 1.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 76936 | |
| Dash Punctuation | 19234 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 24555 | |
| 0 | 21635 | |
| 9 | 13214 | |
| 2 | 3614 | 4.7% |
| 8 | 3119 | 4.1% |
| 6 | 2830 | 3.7% |
| 7 | 2789 | 3.6% |
| 5 | 1822 | 2.4% |
| 4 | 1689 | 2.2% |
| 3 | 1669 | 2.2% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 19234 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 96170 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 24555 | |
| 0 | 21635 | |
| - | 19234 | |
| 9 | 13214 | |
| 2 | 3614 | 3.8% |
| 8 | 3119 | 3.2% |
| 6 | 2830 | 2.9% |
| 7 | 2789 | 2.9% |
| 5 | 1822 | 1.9% |
| 4 | 1689 | 1.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 96170 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 24555 | |
| 0 | 21635 | |
| - | 19234 | |
| 9 | 13214 | |
| 2 | 3614 | 3.8% |
| 8 | 3119 | 3.2% |
| 6 | 2830 | 2.9% |
| 7 | 2789 | 2.9% |
| 5 | 1822 | 1.9% |
| 4 | 1689 | 1.8% |
REJOIN
Categorical
| Distinct | 22 |
|---|---|
| Distinct (%) | 13.3% |
| Missing | 28787 |
| Missing (%) | 99.4% |
| Memory size | 226.3 KiB |
| 1991-01-01 | |
|---|---|
| 1994-01-01 | |
| 1995-11-01 | |
| 1976-01-01 | |
| 1995-02-01 | |
| Other values (17) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 1660 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.6% |
Sample
| 1st row | 2001-07-03 |
|---|---|
| 2nd row | 2001-07-03 |
| 3rd row | 2001-07-03 |
| 4th row | 2001-07-03 |
| 5th row | 2001-07-03 |
Common Values
| Value | Count | Frequency (%) |
| 1991-01-01 | 15 | 0.1% |
| 1994-01-01 | 14 | < 0.1% |
| 1995-11-01 | 11 | < 0.1% |
| 1976-01-01 | 11 | < 0.1% |
| 1995-02-01 | 11 | < 0.1% |
| 2001-07-03 | 11 | < 0.1% |
| 1983-01-01 | 11 | < 0.1% |
| 2003-12-01 | 9 | < 0.1% |
| 2002-04-01 | 9 | < 0.1% |
| 2001-09-01 | 9 | < 0.1% |
| Other values (12) | 55 | 0.2% |
| (Missing) | 28787 |
Length
| Value | Count | Frequency (%) |
| 1991-01-01 | 15 | 9.0% |
| 1994-01-01 | 14 | 8.4% |
| 1995-11-01 | 11 | 6.6% |
| 1976-01-01 | 11 | 6.6% |
| 1995-02-01 | 11 | 6.6% |
| 2001-07-03 | 11 | 6.6% |
| 1983-01-01 | 11 | 6.6% |
| 2003-12-01 | 9 | 5.4% |
| 2002-04-01 | 9 | 5.4% |
| 2001-09-01 | 9 | 5.4% |
| Other values (12) | 55 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 437 | |
| 1 | 397 | |
| - | 332 | |
| 9 | 177 | |
| 2 | 136 | 8.2% |
| 3 | 47 | 2.8% |
| 5 | 39 | 2.3% |
| 8 | 31 | 1.9% |
| 4 | 23 | 1.4% |
| 7 | 23 | 1.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1328 | |
| Dash Punctuation | 332 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 437 | |
| 1 | 397 | |
| 9 | 177 | |
| 2 | 136 | 10.2% |
| 3 | 47 | 3.5% |
| 5 | 39 | 2.9% |
| 8 | 31 | 2.3% |
| 4 | 23 | 1.7% |
| 7 | 23 | 1.7% |
| 6 | 18 | 1.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 332 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1660 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 437 | |
| 1 | 397 | |
| - | 332 | |
| 9 | 177 | |
| 2 | 136 | 8.2% |
| 3 | 47 | 2.8% |
| 5 | 39 | 2.3% |
| 8 | 31 | 1.9% |
| 4 | 23 | 1.4% |
| 7 | 23 | 1.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1660 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 437 | |
| 1 | 397 | |
| - | 332 | |
| 9 | 177 | |
| 2 | 136 | 8.2% |
| 3 | 47 | 2.8% |
| 5 | 39 | 2.3% |
| 8 | 31 | 1.9% |
| 4 | 23 | 1.4% |
| 7 | 23 | 1.4% |
LEFTOFC
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 659 |
|---|---|
| Distinct (%) | 9.0% |
| Missing | 21623 |
| Missing (%) | 74.7% |
| Memory size | 226.3 KiB |
| 2005-12-31 | 98 |
|---|---|
| 2005-07-01 | 66 |
| 2007-01-01 | 63 |
| 2007-07-01 | 59 |
| 2008-01-01 | 58 |
| Other values (654) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 73300 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 10 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 1998-05-20 |
|---|---|
| 2nd row | 2003-04-24 |
| 3rd row | 1998-05-20 |
| 4th row | 2003-04-24 |
| 5th row | 1998-05-20 |
Common Values
| Value | Count | Frequency (%) |
| 2005-12-31 | 98 | 0.3% |
| 2005-07-01 | 66 | 0.2% |
| 2007-01-01 | 63 | 0.2% |
| 2007-07-01 | 59 | 0.2% |
| 2008-01-01 | 58 | 0.2% |
| 2013-01-01 | 51 | 0.2% |
| 2004-07-01 | 48 | 0.2% |
| 1998-12-31 | 47 | 0.2% |
| 2000-12-31 | 46 | 0.2% |
| 2011-01-01 | 45 | 0.2% |
| Other values (649) | 6749 | 23.3% |
| (Missing) | 21623 |
Length
| Value | Count | Frequency (%) |
| 2005-12-31 | 98 | 1.3% |
| 2005-07-01 | 66 | 0.9% |
| 2007-01-01 | 63 | 0.9% |
| 2007-07-01 | 59 | 0.8% |
| 2008-01-01 | 58 | 0.8% |
| 2013-01-01 | 51 | 0.7% |
| 2004-07-01 | 48 | 0.7% |
| 1998-12-31 | 47 | 0.6% |
| 2000-12-31 | 46 | 0.6% |
| 2011-01-01 | 45 | 0.6% |
| Other values (649) | 6749 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 20742 | |
| - | 14660 | |
| 1 | 12873 | |
| 2 | 9966 | |
| 9 | 3803 | 5.2% |
| 3 | 3125 | 4.3% |
| 5 | 1933 | 2.6% |
| 4 | 1785 | 2.4% |
| 7 | 1732 | 2.4% |
| 6 | 1368 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 58640 | |
| Dash Punctuation | 14660 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 20742 | |
| 1 | 12873 | |
| 2 | 9966 | |
| 9 | 3803 | 6.5% |
| 3 | 3125 | 5.3% |
| 5 | 1933 | 3.3% |
| 4 | 1785 | 3.0% |
| 7 | 1732 | 3.0% |
| 6 | 1368 | 2.3% |
| 8 | 1313 | 2.2% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 14660 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 73300 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 20742 | |
| - | 14660 | |
| 1 | 12873 | |
| 2 | 9966 | |
| 9 | 3803 | 5.2% |
| 3 | 3125 | 4.3% |
| 5 | 1933 | 2.6% |
| 4 | 1785 | 2.4% |
| 7 | 1732 | 2.4% |
| 6 | 1368 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 73300 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 20742 | |
| - | 14660 | |
| 1 | 12873 | |
| 2 | 9966 | |
| 9 | 3803 | 5.2% |
| 3 | 3125 | 4.3% |
| 5 | 1933 | 2.6% |
| 4 | 1785 | 2.4% |
| 7 | 1732 | 2.4% |
| 6 | 1368 | 1.9% |
LEFTCO
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 780 |
|---|---|
| Distinct (%) | 8.8% |
| Missing | 20082 |
| Missing (%) | 69.4% |
| Memory size | 226.3 KiB |
| 2005-12-31 | 165 |
|---|---|
| 2007-12-31 | 147 |
| 2004-12-31 | 130 |
| 2008-12-31 | 126 |
| 1999-12-31 | 112 |
| Other values (775) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 88710 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 17 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | 1998-12-31 |
|---|---|
| 2nd row | 2002-04-01 |
| 3rd row | 2003-04-24 |
| 4th row | 2002-09-17 |
| 5th row | 1995-01-15 |
Common Values
| Value | Count | Frequency (%) |
| 2005-12-31 | 165 | 0.6% |
| 2007-12-31 | 147 | 0.5% |
| 2004-12-31 | 130 | 0.4% |
| 2008-12-31 | 126 | 0.4% |
| 1999-12-31 | 112 | 0.4% |
| 2002-12-31 | 97 | 0.3% |
| 2003-12-31 | 93 | 0.3% |
| 1998-12-31 | 83 | 0.3% |
| 2006-12-31 | 83 | 0.3% |
| 2002-01-01 | 61 | 0.2% |
| Other values (770) | 7774 | 26.9% |
| (Missing) | 20082 |
Length
| Value | Count | Frequency (%) |
| 2005-12-31 | 165 | 1.9% |
| 2007-12-31 | 147 | 1.7% |
| 2004-12-31 | 130 | 1.5% |
| 2008-12-31 | 126 | 1.4% |
| 1999-12-31 | 112 | 1.3% |
| 2002-12-31 | 97 | 1.1% |
| 2003-12-31 | 93 | 1.0% |
| 1998-12-31 | 83 | 0.9% |
| 2006-12-31 | 83 | 0.9% |
| 2002-01-01 | 61 | 0.7% |
| Other values (770) | 7774 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 25332 | |
| - | 17742 | |
| 1 | 13635 | |
| 2 | 11084 | |
| 9 | 5938 | 6.7% |
| 3 | 4870 | 5.5% |
| 7 | 2226 | 2.5% |
| 5 | 2057 | 2.3% |
| 8 | 2028 | 2.3% |
| 6 | 1924 | 2.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 70968 | |
| Dash Punctuation | 17742 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 25332 | |
| 1 | 13635 | |
| 2 | 11084 | |
| 9 | 5938 | 8.4% |
| 3 | 4870 | 6.9% |
| 7 | 2226 | 3.1% |
| 5 | 2057 | 2.9% |
| 8 | 2028 | 2.9% |
| 6 | 1924 | 2.7% |
| 4 | 1874 | 2.6% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 17742 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 88710 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 25332 | |
| - | 17742 | |
| 1 | 13635 | |
| 2 | 11084 | |
| 9 | 5938 | 6.7% |
| 3 | 4870 | 5.5% |
| 7 | 2226 | 2.5% |
| 5 | 2057 | 2.3% |
| 8 | 2028 | 2.3% |
| 6 | 1924 | 2.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 88710 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 25332 | |
| - | 17742 | |
| 1 | 13635 | |
| 2 | 11084 | |
| 9 | 5938 | 6.7% |
| 3 | 4870 | 5.5% |
| 7 | 2226 | 2.5% |
| 5 | 2057 | 2.3% |
| 8 | 2028 | 2.3% |
| 6 | 1924 | 2.2% |
RELEFT
Categorical
| Distinct | 9 |
|---|---|
| Distinct (%) | 12.9% |
| Missing | 28883 |
| Missing (%) | 99.8% |
| Memory size | 226.3 KiB |
| 2006-10-18 | |
|---|---|
| 2002-07-01 | |
| 2006-12-31 | |
| 2002-04-25 | |
| 2005-04-01 | |
| Other values (4) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 700 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2002-07-01 |
|---|---|
| 2nd row | 2002-07-01 |
| 3rd row | 2002-07-01 |
| 4th row | 2002-07-01 |
| 5th row | 2002-07-01 |
Common Values
| Value | Count | Frequency (%) |
| 2006-10-18 | 12 | < 0.1% |
| 2002-07-01 | 11 | < 0.1% |
| 2006-12-31 | 11 | < 0.1% |
| 2002-04-25 | 11 | < 0.1% |
| 2005-04-01 | 9 | < 0.1% |
| 2005-02-01 | 6 | < 0.1% |
| 1997-07-01 | 6 | < 0.1% |
| 1994-12-31 | 2 | < 0.1% |
| 1996-11-20 | 2 | < 0.1% |
| (Missing) | 28883 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2006-10-18 | 12 | |
| 2002-07-01 | 11 | |
| 2006-12-31 | 11 | |
| 2002-04-25 | 11 | |
| 2005-04-01 | 9 | |
| 2005-02-01 | 6 | |
| 1997-07-01 | 6 | |
| 1994-12-31 | 2 | 2.9% |
| 1996-11-20 | 2 | 2.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 209 | |
| - | 140 | |
| 2 | 114 | |
| 1 | 96 | |
| 5 | 26 | 3.7% |
| 6 | 25 | 3.6% |
| 7 | 23 | 3.3% |
| 4 | 22 | 3.1% |
| 9 | 20 | 2.9% |
| 3 | 13 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 560 | |
| Dash Punctuation | 140 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 209 | |
| 2 | 114 | |
| 1 | 96 | |
| 5 | 26 | 4.6% |
| 6 | 25 | 4.5% |
| 7 | 23 | 4.1% |
| 4 | 22 | 3.9% |
| 9 | 20 | 3.6% |
| 3 | 13 | 2.3% |
| 8 | 12 | 2.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 140 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 700 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 209 | |
| - | 140 | |
| 2 | 114 | |
| 1 | 96 | |
| 5 | 26 | 3.7% |
| 6 | 25 | 3.6% |
| 7 | 23 | 3.3% |
| 4 | 22 | 3.1% |
| 9 | 20 | 2.9% |
| 3 | 13 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 700 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 209 | |
| - | 140 | |
| 2 | 114 | |
| 1 | 96 | |
| 5 | 26 | 3.7% |
| 6 | 25 | 3.6% |
| 7 | 23 | 3.3% |
| 4 | 22 | 3.1% |
| 9 | 20 | 2.9% |
| 3 | 13 | 1.9% |
PCEO
Categorical
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 28285 |
| Missing (%) | 97.7% |
| Memory size | 226.3 KiB |
| CEO |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 2004 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CEO |
|---|---|
| 2nd row | CEO |
| 3rd row | CEO |
| 4th row | CEO |
| 5th row | CEO |
Common Values
| Value | Count | Frequency (%) |
| CEO | 668 | 2.3% |
| (Missing) | 28285 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| ceo | 668 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 668 | |
| E | 668 | |
| O | 668 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2004 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 668 | |
| E | 668 | |
| O | 668 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2004 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 668 | |
| E | 668 | |
| O | 668 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2004 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| C | 668 | |
| E | 668 | |
| O | 668 |
PCFO
Categorical
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 28858 |
| Missing (%) | 99.7% |
| Memory size | 226.3 KiB |
| CFO |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 285 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CFO |
|---|---|
| 2nd row | CFO |
| 3rd row | CFO |
| 4th row | CFO |
| 5th row | CFO |
Common Values
| Value | Count | Frequency (%) |
| CFO | 95 | 0.3% |
| (Missing) | 28858 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| cfo | 95 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 95 | |
| F | 95 | |
| O | 95 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 285 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 95 | |
| F | 95 | |
| O | 95 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 285 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 95 | |
| F | 95 | |
| O | 95 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 285 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| C | 95 | |
| F | 95 | |
| O | 95 |
TITLE
Categorical
| Distinct | 2655 |
|---|---|
| Distinct (%) | 9.2% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Memory size | 226.3 KiB |
| chairman & CEO | 1093 |
|---|---|
| chairman | 965 |
| executive vp | 891 |
| vice chairman | 681 |
| Executive Chairman | 585 |
| Other values (2650) |
Length
| Max length | 231 |
|---|---|
| Median length | 175 |
| Mean length | 29.985664 |
| Min length | 3 |
Characters and Unicode
| Total characters | 868025 |
|---|---|
| Distinct characters | 64 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 125 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | chmn., pres. & CEO |
|---|---|
| 2nd row | vice chairman |
| 3rd row | chairman & CEO |
| 4th row | executive vp; executive vp-marketing & planning-American |
| 5th row | sr. v-p |
Common Values
| Value | Count | Frequency (%) |
| chairman & CEO | 1093 | 3.8% |
| chairman | 965 | 3.3% |
| executive vp | 891 | 3.1% |
| vice chairman | 681 | 2.4% |
| Executive Chairman | 585 | 2.0% |
| exec. v-p | 569 | 2.0% |
| senior vp | 497 | 1.7% |
| sr. v-p | 378 | 1.3% |
| chmn. & CEO | 377 | 1.3% |
| president & chief operating officer | 349 | 1.2% |
| Other values (2645) | 22563 |
Length
| Value | Count | Frequency (%) |
| 11818 | 9.5% | |
| executive | 8796 | 7.1% |
| chairman | 8224 | 6.6% |
| president | 5684 | 4.6% |
| chief | 5639 | 4.5% |
| officer | 5562 | 4.5% |
| vp | 5002 | 4.0% |
| of | 4367 | 3.5% |
| and | 4237 | 3.4% |
| vice | 3989 | 3.2% |
| Other values (2066) | 61004 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 99729 | 11.5% |
| 95491 | 11.0% | |
| i | 69579 | 8.0% |
| r | 58312 | 6.7% |
| n | 52870 | 6.1% |
| c | 45866 | 5.3% |
| a | 45528 | 5.2% |
| t | 37407 | 4.3% |
| o | 35865 | 4.1% |
| s | 29418 | 3.4% |
| Other values (54) | 297960 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 668144 | |
| Space Separator | 95491 | 11.0% |
| Uppercase Letter | 64868 | 7.5% |
| Other Punctuation | 26342 | 3.0% |
| Dash Punctuation | 13081 | 1.5% |
| Close Punctuation | 40 | < 0.1% |
| Open Punctuation | 40 | < 0.1% |
| Decimal Number | 19 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 99729 | |
| i | 69579 | |
| r | 58312 | 8.7% |
| n | 52870 | 7.9% |
| c | 45866 | 6.9% |
| a | 45528 | 6.8% |
| t | 37407 | 5.6% |
| o | 35865 | 5.4% |
| s | 29418 | 4.4% |
| f | 27894 | 4.2% |
| Other values (16) | 165676 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 16901 | |
| E | 10838 | |
| O | 9424 | |
| P | 5460 | 8.4% |
| V | 2976 | 4.6% |
| S | 2825 | 4.4% |
| F | 2208 | 3.4% |
| A | 2122 | 3.3% |
| D | 1872 | 2.9% |
| M | 1860 | 2.9% |
| Other values (16) | 8382 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 11989 | |
| . | 7912 | |
| , | 5008 | |
| ; | 1291 | 4.9% |
| / | 79 | 0.3% |
| ' | 63 | 0.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 13 | |
| 4 | 6 |
Space Separator
| Value | Count | Frequency (%) |
| 95491 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 13081 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 40 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 40 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 733012 | |
| Common | 135013 | 15.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 99729 | |
| i | 69579 | 9.5% |
| r | 58312 | 8.0% |
| n | 52870 | 7.2% |
| c | 45866 | 6.3% |
| a | 45528 | 6.2% |
| t | 37407 | 5.1% |
| o | 35865 | 4.9% |
| s | 29418 | 4.0% |
| f | 27894 | 3.8% |
| Other values (42) | 230544 |
Common
| Value | Count | Frequency (%) |
| 95491 | ||
| - | 13081 | 9.7% |
| & | 11989 | 8.9% |
| . | 7912 | 5.9% |
| , | 5008 | 3.7% |
| ; | 1291 | 1.0% |
| / | 79 | 0.1% |
| ' | 63 | < 0.1% |
| ) | 40 | < 0.1% |
| ( | 40 | < 0.1% |
| Other values (2) | 19 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 868025 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 99729 | 11.5% |
| 95491 | 11.0% | |
| i | 69579 | 8.0% |
| r | 58312 | 6.7% |
| n | 52870 | 6.1% |
| c | 45866 | 5.3% |
| a | 45528 | 5.2% |
| t | 37407 | 4.3% |
| o | 35865 | 4.1% |
| s | 29418 | 3.4% |
| Other values (54) | 297960 |
REASON
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 20141 |
| Missing (%) | 69.6% |
| Memory size | 226.3 KiB |
| RETIRED | |
|---|---|
| RESIGNED | |
| UNKNOWN | |
| DECEASED | 133 |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 7.2652065 |
| Min length | 7 |
Characters and Unicode
| Total characters | 64021 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | RETIRED |
|---|---|
| 2nd row | RETIRED |
| 3rd row | RESIGNED |
| 4th row | RETIRED |
| 5th row | RETIRED |
Common Values
| Value | Count | Frequency (%) |
| RETIRED | 5619 | 19.4% |
| RESIGNED | 2204 | 7.6% |
| UNKNOWN | 856 | 3.0% |
| DECEASED | 133 | 0.5% |
| (Missing) | 20141 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| retired | 5619 | |
| resigned | 2204 | 25.0% |
| unknown | 856 | 9.7% |
| deceased | 133 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 16045 | |
| R | 13442 | |
| D | 8089 | |
| I | 7823 | |
| T | 5619 | 8.8% |
| N | 4772 | 7.5% |
| S | 2337 | 3.7% |
| G | 2204 | 3.4% |
| U | 856 | 1.3% |
| K | 856 | 1.3% |
| Other values (4) | 1978 | 3.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 64021 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 16045 | |
| R | 13442 | |
| D | 8089 | |
| I | 7823 | |
| T | 5619 | 8.8% |
| N | 4772 | 7.5% |
| S | 2337 | 3.7% |
| G | 2204 | 3.4% |
| U | 856 | 1.3% |
| K | 856 | 1.3% |
| Other values (4) | 1978 | 3.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 64021 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 16045 | |
| R | 13442 | |
| D | 8089 | |
| I | 7823 | |
| T | 5619 | 8.8% |
| N | 4772 | 7.5% |
| S | 2337 | 3.7% |
| G | 2204 | 3.4% |
| U | 856 | 1.3% |
| K | 856 | 1.3% |
| Other values (4) | 1978 | 3.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 64021 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 16045 | |
| R | 13442 | |
| D | 8089 | |
| I | 7823 | |
| T | 5619 | 8.8% |
| N | 4772 | 7.5% |
| S | 2337 | 3.7% |
| G | 2204 | 3.4% |
| U | 856 | 1.3% |
| K | 856 | 1.3% |
| Other values (4) | 1978 | 3.1% |
EXEC_LNAME
Categorical
| Distinct | 3976 |
|---|---|
| Distinct (%) | 13.7% |
| Missing | 6 |
| Missing (%) | < 0.1% |
| Memory size | 226.3 KiB |
| Smith | 208 |
|---|---|
| Johnson | 202 |
| Miller | 124 |
| Lewis | 88 |
| Campbell | 87 |
| Other values (3971) |
Length
| Max length | 20 |
|---|---|
| Median length | 18 |
| Mean length | 7.244274 |
| Min length | 2 |
Characters and Unicode
| Total characters | 209700 |
|---|---|
| Distinct characters | 59 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 152 ? |
|---|---|
| Unique (%) | 0.5% |
Sample
| 1st row | Crandall |
|---|---|
| 2nd row | Baker |
| 3rd row | Carty |
| 4th row | Gunn |
| 5th row | Hopper |
Common Values
| Value | Count | Frequency (%) |
| Smith | 208 | 0.7% |
| Johnson | 202 | 0.7% |
| Miller | 124 | 0.4% |
| Lewis | 88 | 0.3% |
| Campbell | 87 | 0.3% |
| Williams | 86 | 0.3% |
| Thompson | 75 | 0.3% |
| Kelly | 71 | 0.2% |
| Ryan | 70 | 0.2% |
| Sullivan | 67 | 0.2% |
| Other values (3966) | 27869 |
Length
| Value | Count | Frequency (%) |
| jr | 1640 | 5.0% |
| iii | 412 | 1.3% |
| ph.d | 256 | 0.8% |
| smith | 247 | 0.8% |
| johnson | 221 | 0.7% |
| cpa | 207 | 0.6% |
| miller | 137 | 0.4% |
| ii | 114 | 0.3% |
| m.b.a | 105 | 0.3% |
| lewis | 97 | 0.3% |
| Other values (3839) | 29357 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 20427 | 9.7% |
| r | 16600 | 7.9% |
| a | 15154 | 7.2% |
| n | 15094 | 7.2% |
| o | 12613 | 6.0% |
| l | 12063 | 5.8% |
| i | 11171 | 5.3% |
| s | 8595 | 4.1% |
| t | 7788 | 3.7% |
| h | 5903 | 2.8% |
| Other values (49) | 84292 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 161847 | |
| Uppercase Letter | 36643 | 17.5% |
| Other Punctuation | 7274 | 3.5% |
| Space Separator | 3846 | 1.8% |
| Dash Punctuation | 74 | < 0.1% |
| Open Punctuation | 11 | < 0.1% |
| Close Punctuation | 5 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 20427 | |
| r | 16600 | |
| a | 15154 | |
| n | 15094 | |
| o | 12613 | 7.8% |
| l | 12063 | 7.5% |
| i | 11171 | 6.9% |
| s | 8595 | 5.3% |
| t | 7788 | 4.8% |
| h | 5903 | 3.6% |
| Other values (16) | 36439 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 3315 | 9.0% |
| B | 3101 | 8.5% |
| M | 3066 | 8.4% |
| C | 2747 | 7.5% |
| J | 2554 | 7.0% |
| H | 1926 | 5.3% |
| D | 1915 | 5.2% |
| W | 1831 | 5.0% |
| P | 1802 | 4.9% |
| G | 1767 | 4.8% |
| Other values (16) | 12619 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 3602 | |
| , | 3398 | |
| ' | 274 | 3.8% |
Space Separator
| Value | Count | Frequency (%) |
| 3846 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 74 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 11 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 198490 | |
| Common | 11210 | 5.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 20427 | 10.3% |
| r | 16600 | 8.4% |
| a | 15154 | 7.6% |
| n | 15094 | 7.6% |
| o | 12613 | 6.4% |
| l | 12063 | 6.1% |
| i | 11171 | 5.6% |
| s | 8595 | 4.3% |
| t | 7788 | 3.9% |
| h | 5903 | 3.0% |
| Other values (42) | 73082 |
Common
| Value | Count | Frequency (%) |
| 3846 | ||
| . | 3602 | |
| , | 3398 | |
| ' | 274 | 2.4% |
| - | 74 | 0.7% |
| ( | 11 | 0.1% |
| ) | 5 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 209700 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 20427 | 9.7% |
| r | 16600 | 7.9% |
| a | 15154 | 7.2% |
| n | 15094 | 7.2% |
| o | 12613 | 6.0% |
| l | 12063 | 5.8% |
| i | 11171 | 5.3% |
| s | 8595 | 4.1% |
| t | 7788 | 3.7% |
| h | 5903 | 2.8% |
| Other values (49) | 84292 |
EXEC_FNAME
Categorical
| Distinct | 811 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 6 |
| Missing (%) | < 0.1% |
| Memory size | 226.3 KiB |
| John | 1856 |
|---|---|
| Robert | 1439 |
| James | 1336 |
| William | 1120 |
| David | 1079 |
| Other values (806) |
Length
| Max length | 16 |
|---|---|
| Median length | 14 |
| Mean length | 5.4888589 |
| Min length | 2 |
Characters and Unicode
| Total characters | 158886 |
|---|---|
| Distinct characters | 55 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 25 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Robert |
|---|---|
| 2nd row | Robert |
| 3rd row | Donald |
| 4th row | Michael |
| 5th row | Max |
Common Values
| Value | Count | Frequency (%) |
| John | 1856 | 6.4% |
| Robert | 1439 | 5.0% |
| James | 1336 | 4.6% |
| William | 1120 | 3.9% |
| David | 1079 | 3.7% |
| Michael | 956 | 3.3% |
| Richard | 937 | 3.2% |
| Thomas | 793 | 2.7% |
| Charles | 500 | 1.7% |
| Joseph | 403 | 1.4% |
| Other values (801) | 18528 |
Length
| Value | Count | Frequency (%) |
| john | 1859 | 6.4% |
| robert | 1444 | 5.0% |
| james | 1336 | 4.6% |
| william | 1134 | 3.9% |
| david | 1084 | 3.7% |
| michael | 964 | 3.3% |
| richard | 937 | 3.2% |
| thomas | 793 | 2.7% |
| charles | 503 | 1.7% |
| joseph | 403 | 1.4% |
| Other values (788) | 18600 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 15956 | 10.0% |
| a | 15893 | 10.0% |
| r | 12689 | 8.0% |
| n | 9941 | 6.3% |
| i | 9610 | 6.0% |
| o | 9197 | 5.8% |
| l | 8921 | 5.6% |
| h | 7991 | 5.0% |
| d | 5426 | 3.4% |
| t | 5248 | 3.3% |
| Other values (45) | 58014 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 127596 | |
| Uppercase Letter | 29151 | 18.3% |
| Other Punctuation | 1948 | 1.2% |
| Space Separator | 110 | 0.1% |
| Dash Punctuation | 81 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 15956 | |
| a | 15893 | |
| r | 12689 | |
| n | 9941 | 7.8% |
| i | 9610 | 7.5% |
| o | 9197 | 7.2% |
| l | 8921 | 7.0% |
| h | 7991 | 6.3% |
| d | 5426 | 4.3% |
| t | 5248 | 4.1% |
| Other values (16) | 26724 |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 5048 | |
| R | 3651 | |
| D | 2760 | 9.5% |
| M | 2151 | 7.4% |
| W | 1796 | 6.2% |
| G | 1460 | 5.0% |
| S | 1406 | 4.8% |
| C | 1321 | 4.5% |
| T | 1273 | 4.4% |
| P | 1253 | 4.3% |
| Other values (16) | 7032 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 1948 |
Space Separator
| Value | Count | Frequency (%) |
| 110 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 81 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 156747 | |
| Common | 2139 | 1.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 15956 | 10.2% |
| a | 15893 | 10.1% |
| r | 12689 | 8.1% |
| n | 9941 | 6.3% |
| i | 9610 | 6.1% |
| o | 9197 | 5.9% |
| l | 8921 | 5.7% |
| h | 7991 | 5.1% |
| d | 5426 | 3.5% |
| t | 5248 | 3.3% |
| Other values (42) | 55875 |
Common
| Value | Count | Frequency (%) |
| . | 1948 | |
| 110 | 5.1% | |
| - | 81 | 3.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 158886 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 15956 | 10.0% |
| a | 15893 | 10.0% |
| r | 12689 | 8.0% |
| n | 9941 | 6.3% |
| i | 9610 | 6.0% |
| o | 9197 | 5.8% |
| l | 8921 | 5.6% |
| h | 7991 | 5.0% |
| d | 5426 | 3.4% |
| t | 5248 | 3.3% |
| Other values (45) | 58014 |
GENDER
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 226.3 KiB |
| MALE | |
|---|---|
| FEMALE | 1136 |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.078472 |
| Min length | 4 |
Characters and Unicode
| Total characters | 118084 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MALE |
|---|---|
| 2nd row | MALE |
| 3rd row | MALE |
| 4th row | MALE |
| 5th row | MALE |
Common Values
| Value | Count | Frequency (%) |
| MALE | 27817 | |
| FEMALE | 1136 | 3.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| male | 27817 | |
| female | 1136 | 3.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 30089 | |
| M | 28953 | |
| A | 28953 | |
| L | 28953 | |
| F | 1136 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 118084 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 30089 | |
| M | 28953 | |
| A | 28953 | |
| L | 28953 | |
| F | 1136 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 118084 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 30089 | |
| M | 28953 | |
| A | 28953 | |
| L | 28953 | |
| F | 1136 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 118084 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 30089 | |
| M | 28953 | |
| A | 28953 | |
| L | 28953 | |
| F | 1136 | 1.0% |
PAGE
Real number (ℝ)
| Distinct | 60 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 7491 |
| Missing (%) | 25.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 74.339763 |
| Minimum | 46 |
|---|---|
| Maximum | 111 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 226.3 KiB |
Quantile statistics
| Minimum | 46 |
|---|---|
| 5-th percentile | 61 |
| Q1 | 68 |
| median | 74 |
| Q3 | 80 |
| 95-th percentile | 89 |
| Maximum | 111 |
| Range | 65 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 8.759284 |
|---|---|
| Coefficient of variation (CV) | 0.11782771 |
| Kurtosis | 0.11442876 |
| Mean | 74.339763 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0.27743578 |
| Sum | 1595480 |
| Variance | 76.725057 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 75 | 1195 | 4.1% |
| 74 | 1045 | 3.6% |
| 73 | 999 | 3.5% |
| 71 | 949 | 3.3% |
| 72 | 934 | 3.2% |
| 79 | 933 | 3.2% |
| 76 | 902 | 3.1% |
| 69 | 876 | 3.0% |
| 80 | 780 | 2.7% |
| 67 | 776 | 2.7% |
| Other values (50) | 12073 | |
| (Missing) | 7491 |
| Value | Count | Frequency (%) |
| 46 | 10 | < 0.1% |
| 48 | 2 | < 0.1% |
| 49 | 9 | < 0.1% |
| 51 | 10 | < 0.1% |
| 52 | 19 | 0.1% |
| 53 | 31 | 0.1% |
| 54 | 48 | |
| 55 | 43 | |
| 56 | 48 | |
| 57 | 94 |
| Value | Count | Frequency (%) |
| 111 | 3 | < 0.1% |
| 108 | 4 | < 0.1% |
| 106 | 39 | |
| 105 | 6 | < 0.1% |
| 104 | 6 | < 0.1% |
| 102 | 14 | < 0.1% |
| 101 | 13 | < 0.1% |
| 100 | 42 | |
| 99 | 9 | < 0.1% |
| 98 | 45 |
CUSIP
Categorical
| Distinct | 386 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 226.3 KiB |
| 69331C10 | 138 |
|---|---|
| 28102010 | 124 |
| 80851310 | 118 |
| 20825C10 | 112 |
| 34537086 | 111 |
| Other values (381) |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 231624 |
|---|---|
| Distinct characters | 33 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 02376R10 |
|---|---|
| 2nd row | 02376R10 |
| 3rd row | 02376R10 |
| 4th row | 02376R10 |
| 5th row | 02376R10 |
Common Values
| Value | Count | Frequency (%) |
| 69331C10 | 138 | 0.5% |
| 28102010 | 124 | 0.4% |
| 80851310 | 118 | 0.4% |
| 20825C10 | 112 | 0.4% |
| 34537086 | 111 | 0.4% |
| 12589610 | 109 | 0.4% |
| 59511210 | 108 | 0.4% |
| 02687478 | 107 | 0.4% |
| 30161N10 | 106 | 0.4% |
| 96945710 | 106 | 0.4% |
| Other values (376) | 27814 |
Length
| Value | Count | Frequency (%) |
| 69331c10 | 138 | 0.5% |
| 28102010 | 124 | 0.4% |
| 80851310 | 118 | 0.4% |
| 20825c10 | 112 | 0.4% |
| 34537086 | 111 | 0.4% |
| 12589610 | 109 | 0.4% |
| 59511210 | 108 | 0.4% |
| 02687478 | 107 | 0.4% |
| 30161n10 | 106 | 0.4% |
| 96945710 | 106 | 0.4% |
| Other values (376) | 27814 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 48712 | |
| 1 | 43855 | |
| 4 | 18076 | 7.8% |
| 3 | 17242 | 7.4% |
| 2 | 16657 | 7.2% |
| 6 | 16590 | 7.2% |
| 5 | 16346 | 7.1% |
| 7 | 15283 | 6.6% |
| 8 | 15216 | 6.6% |
| 9 | 13560 | 5.9% |
| Other values (23) | 10087 | 4.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 221537 | |
| Uppercase Letter | 10087 | 4.4% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 1251 | 12.4% |
| L | 864 | 8.6% |
| R | 720 | 7.1% |
| E | 711 | 7.0% |
| C | 644 | 6.4% |
| H | 625 | 6.2% |
| P | 548 | 5.4% |
| T | 501 | 5.0% |
| V | 468 | 4.6% |
| F | 430 | 4.3% |
| Other values (13) | 3325 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 48712 | |
| 1 | 43855 | |
| 4 | 18076 | 8.2% |
| 3 | 17242 | 7.8% |
| 2 | 16657 | 7.5% |
| 6 | 16590 | 7.5% |
| 5 | 16346 | 7.4% |
| 7 | 15283 | 6.9% |
| 8 | 15216 | 6.9% |
| 9 | 13560 | 6.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 221537 | |
| Latin | 10087 | 4.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| G | 1251 | 12.4% |
| L | 864 | 8.6% |
| R | 720 | 7.1% |
| E | 711 | 7.0% |
| C | 644 | 6.4% |
| H | 625 | 6.2% |
| P | 548 | 5.4% |
| T | 501 | 5.0% |
| V | 468 | 4.6% |
| F | 430 | 4.3% |
| Other values (13) | 3325 |
Common
| Value | Count | Frequency (%) |
| 0 | 48712 | |
| 1 | 43855 | |
| 4 | 18076 | 8.2% |
| 3 | 17242 | 7.8% |
| 2 | 16657 | 7.5% |
| 6 | 16590 | 7.5% |
| 5 | 16346 | 7.4% |
| 7 | 15283 | 6.9% |
| 8 | 15216 | 6.9% |
| 9 | 13560 | 6.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 231624 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 48712 | |
| 1 | 43855 | |
| 4 | 18076 | 7.8% |
| 3 | 17242 | 7.4% |
| 2 | 16657 | 7.2% |
| 6 | 16590 | 7.2% |
| 5 | 16346 | 7.1% |
| 7 | 15283 | 6.6% |
| 8 | 15216 | 6.6% |
| 9 | 13560 | 5.9% |
| Other values (23) | 10087 | 4.4% |
TICKER
Categorical
| Distinct | 386 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 226.3 KiB |
| PCG | 138 |
|---|---|
| EIX | 124 |
| SCHW | 118 |
| COP | 112 |
| F | 111 |
| Other values (381) |
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 3.0498739 |
| Min length | 1 |
Characters and Unicode
| Total characters | 88303 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | AAL |
|---|---|
| 2nd row | AAL |
| 3rd row | AAL |
| 4th row | AAL |
| 5th row | AAL |
Common Values
| Value | Count | Frequency (%) |
| PCG | 138 | 0.5% |
| EIX | 124 | 0.4% |
| SCHW | 118 | 0.4% |
| COP | 112 | 0.4% |
| F | 111 | 0.4% |
| CMS | 109 | 0.4% |
| MU | 108 | 0.4% |
| AIG | 107 | 0.4% |
| EXC | 106 | 0.4% |
| WMB | 106 | 0.4% |
| Other values (376) | 27814 |
Length
| Value | Count | Frequency (%) |
| pcg | 138 | 0.5% |
| eix | 124 | 0.4% |
| schw | 118 | 0.4% |
| cop | 112 | 0.4% |
| f | 111 | 0.4% |
| cms | 109 | 0.4% |
| mu | 108 | 0.4% |
| aig | 107 | 0.4% |
| exc | 106 | 0.4% |
| wmb | 106 | 0.4% |
| Other values (376) | 27814 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 6535 | 7.4% |
| C | 6531 | 7.4% |
| M | 5668 | 6.4% |
| T | 5323 | 6.0% |
| S | 5189 | 5.9% |
| E | 4742 | 5.4% |
| P | 4642 | 5.3% |
| L | 4310 | 4.9% |
| R | 4277 | 4.8% |
| N | 4205 | 4.8% |
| Other values (17) | 36881 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 88175 | |
| Other Punctuation | 128 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 6535 | 7.4% |
| C | 6531 | 7.4% |
| M | 5668 | 6.4% |
| T | 5323 | 6.0% |
| S | 5189 | 5.9% |
| E | 4742 | 5.4% |
| P | 4642 | 5.3% |
| L | 4310 | 4.9% |
| R | 4277 | 4.9% |
| N | 4205 | 4.8% |
| Other values (16) | 36753 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 128 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 88175 | |
| Common | 128 | 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 6535 | 7.4% |
| C | 6531 | 7.4% |
| M | 5668 | 6.4% |
| T | 5323 | 6.0% |
| S | 5189 | 5.9% |
| E | 4742 | 5.4% |
| P | 4642 | 5.3% |
| L | 4310 | 4.9% |
| R | 4277 | 4.9% |
| N | 4205 | 4.8% |
| Other values (16) | 36753 |
Common
| Value | Count | Frequency (%) |
| . | 128 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 88303 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 6535 | 7.4% |
| C | 6531 | 7.4% |
| M | 5668 | 6.4% |
| T | 5323 | 6.0% |
| S | 5189 | 5.9% |
| E | 4742 | 5.4% |
| P | 4642 | 5.3% |
| L | 4310 | 4.9% |
| R | 4277 | 4.8% |
| N | 4205 | 4.8% |
| Other values (17) | 36881 |
NAICS
Real number (ℝ)
| Distinct | 178 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 354630.62 |
| Minimum | 42 |
|---|---|
| Maximum | 999977 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 226.3 KiB |
Quantile statistics
| Minimum | 42 |
|---|---|
| 5-th percentile | 2211 |
| Q1 | 316210 |
| median | 334516 |
| Q3 | 518210 |
| 95-th percentile | 561450 |
| Maximum | 999977 |
| Range | 999935 |
| Interquartile range (IQR) | 202000 |
Descriptive statistics
| Standard deviation | 188315.87 |
|---|---|
| Coefficient of variation (CV) | 0.53101977 |
| Kurtosis | 0.057663453 |
| Mean | 354630.62 |
| Median Absolute Deviation (MAD) | 147595 |
| Skewness | -0.40580918 |
| Sum | 1.026762 × 1010 |
| Variance | 3.5462867 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 522110 | 1465 | 5.1% |
| 22111 | 1272 | 4.4% |
| 2211 | 1116 | 3.9% |
| 2111 | 806 | 2.8% |
| 325412 | 792 | 2.7% |
| 334413 | 779 | 2.7% |
| 524126 | 713 | 2.5% |
| 334516 | 493 | 1.7% |
| 518210 | 479 | 1.7% |
| 481111 | 419 | 1.4% |
| Other values (168) | 20619 |
| Value | Count | Frequency (%) |
| 42 | 84 | 0.3% |
| 315 | 103 | 0.4% |
| 321 | 82 | 0.3% |
| 325 | 84 | 0.3% |
| 423 | 40 | 0.1% |
| 621 | 76 | 0.3% |
| 2111 | 806 | |
| 2211 | 1116 | |
| 3113 | 101 | 0.3% |
| 3352 | 92 | 0.3% |
| Value | Count | Frequency (%) |
| 999977 | 127 | |
| 812331 | 85 | 0.3% |
| 722513 | 228 | |
| 722511 | 67 | 0.2% |
| 721120 | 40 | 0.1% |
| 721110 | 155 | |
| 622110 | 177 | |
| 621511 | 141 | |
| 621492 | 65 | 0.2% |
| 621491 | 83 | 0.3% |
| CFOANN | EXECDIR | REPRICE | EXECRANK | CO_PER_ROL | CONAME | CEOANN | SALARY | BONUS | PENSION_CHG | TOTAL_SEC | TOTAL_CURR | CHG_CTRL_PYMT | AGE | EXECRANKANN | TDC1 | ALLOTHTOT | ALLOTHPD | SAL_PCT | TOTAL_CURR_PCT | TOTAL_SEC_PCT | TDC1_PCT | COMMENT | GVKEY | EXECID | YEAR | BECAMECEO | JOINED_CO | REJOIN | LEFTOFC | LEFTCO | RELEFT | PCEO | PCFO | TITLE | REASON | EXEC_LNAME | EXEC_FNAME | GENDER | PAGE | CUSIP | TICKER | NAICS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | NaN | 1 | 0 | NaN | 1 | AMERICAN AIRLINES GROUP INC | CEO | 600.00 | 0.0 | NaN | NaN | 600.00 | NaN | NaN | 1.0 | 1013.471 | 87.634 | 0.0 | NaN | NaN | NaN | NaN | NaN | 1045 | 58 | 1992 | 1985-03-01 | 1973-04-01 | NaN | 1998-05-20 | 1998-12-31 | NaN | NaN | NaN | chmn., pres. & CEO | RETIRED | Crandall | Robert | MALE | 87.0 | 02376R10 | AAL | 481111 |
| 1 | NaN | 0 | 0 | NaN | 2 | AMERICAN AIRLINES GROUP INC | NaN | 468.75 | 0.0 | NaN | NaN | 468.75 | NaN | NaN | NaN | 1470.664 | 6.820 | 0.0 | NaN | NaN | NaN | NaN | NaN | 1045 | 3660 | 1992 | NaN | NaN | NaN | NaN | 2002-04-01 | NaN | NaN | NaN | vice chairman | RETIRED | Baker | Robert | MALE | NaN | 02376R10 | AAL | 481111 |
| 2 | NaN | 0 | 0 | NaN | 3 | AMERICAN AIRLINES GROUP INC | NaN | 468.75 | 0.0 | NaN | NaN | 468.75 | NaN | NaN | NaN | 1477.225 | 13.381 | 0.0 | NaN | NaN | NaN | NaN | NaN | 1045 | 3661 | 1992 | 1998-05-20 | NaN | NaN | 2003-04-24 | 2003-04-24 | NaN | NaN | NaN | chairman & CEO | RESIGNED | Carty | Donald | MALE | 76.0 | 02376R10 | AAL | 481111 |
| 3 | NaN | 0 | 0 | NaN | 4 | AMERICAN AIRLINES GROUP INC | NaN | 343.75 | 0.0 | NaN | NaN | 343.75 | NaN | NaN | NaN | 718.104 | 4.869 | 0.0 | NaN | NaN | NaN | NaN | NaN | 1045 | 3662 | 1992 | NaN | NaN | NaN | NaN | 2002-09-17 | NaN | NaN | NaN | executive vp; executive vp-marketing & planning-American | RETIRED | Gunn | Michael | MALE | NaN | 02376R10 | AAL | 481111 |
| 4 | NaN | 0 | 0 | NaN | 5 | AMERICAN AIRLINES GROUP INC | NaN | 343.75 | 0.0 | NaN | NaN | 343.75 | NaN | NaN | NaN | 747.463 | 34.228 | 0.0 | NaN | NaN | NaN | NaN | NaN | 1045 | 3663 | 1992 | NaN | NaN | NaN | NaN | 1995-01-15 | NaN | NaN | NaN | sr. v-p | RETIRED | Hopper | Max | MALE | NaN | 02376R10 | AAL | 481111 |
| 5 | NaN | 1 | 0 | NaN | 1 | AMERICAN AIRLINES GROUP INC | CEO | 600.00 | 0.0 | NaN | NaN | 600.00 | NaN | 58.0 | 1.0 | 1003.974 | 73.631 | 0.0 | 0.000 | 0.000 | NaN | -0.937 | NaN | 1045 | 58 | 1993 | 1985-03-01 | 1973-04-01 | NaN | 1998-05-20 | 1998-12-31 | NaN | NaN | NaN | chmn., pres. & CEO | RETIRED | Crandall | Robert | MALE | 87.0 | 02376R10 | AAL | 481111 |
| 6 | NaN | 0 | 0 | NaN | 2 | AMERICAN AIRLINES GROUP INC | NaN | 491.25 | 0.0 | NaN | NaN | 491.25 | NaN | NaN | 2.0 | 1328.595 | 13.280 | 0.0 | 4.800 | 4.800 | NaN | -9.660 | NaN | 1045 | 3660 | 1993 | NaN | NaN | NaN | NaN | 2002-04-01 | NaN | NaN | NaN | vice chairman | RETIRED | Baker | Robert | MALE | NaN | 02376R10 | AAL | 481111 |
| 7 | NaN | 0 | 0 | NaN | 3 | AMERICAN AIRLINES GROUP INC | NaN | 491.25 | 0.0 | NaN | NaN | 491.25 | NaN | NaN | 3.0 | 1328.696 | 13.381 | 0.0 | 4.800 | 4.800 | NaN | -10.055 | NaN | 1045 | 3661 | 1993 | 1998-05-20 | NaN | NaN | 2003-04-24 | 2003-04-24 | NaN | NaN | NaN | chairman & CEO | RESIGNED | Carty | Donald | MALE | 76.0 | 02376R10 | AAL | 481111 |
| 8 | NaN | 0 | 0 | NaN | 4 | AMERICAN AIRLINES GROUP INC | NaN | 362.50 | 0.0 | NaN | NaN | 362.50 | NaN | NaN | 4.0 | 693.602 | 14.041 | 0.0 | 5.455 | 5.455 | NaN | -3.412 | NaN | 1045 | 3662 | 1993 | NaN | NaN | NaN | NaN | 2002-09-17 | NaN | NaN | NaN | executive vp; executive vp-marketing & planning-American | RETIRED | Gunn | Michael | MALE | NaN | 02376R10 | AAL | 481111 |
| 9 | NaN | 0 | 0 | NaN | 5 | AMERICAN AIRLINES GROUP INC | NaN | 356.25 | 0.0 | NaN | NaN | 356.25 | NaN | NaN | 5.0 | 691.359 | 32.108 | 0.0 | 3.636 | 3.636 | NaN | -7.506 | NaN | 1045 | 3663 | 1993 | NaN | NaN | NaN | NaN | 1995-01-15 | NaN | NaN | NaN | sr. v-p | RETIRED | Hopper | Max | MALE | NaN | 02376R10 | AAL | 481111 |
| CFOANN | EXECDIR | REPRICE | EXECRANK | CO_PER_ROL | CONAME | CEOANN | SALARY | BONUS | PENSION_CHG | TOTAL_SEC | TOTAL_CURR | CHG_CTRL_PYMT | AGE | EXECRANKANN | TDC1 | ALLOTHTOT | ALLOTHPD | SAL_PCT | TOTAL_CURR_PCT | TOTAL_SEC_PCT | TDC1_PCT | COMMENT | GVKEY | EXECID | YEAR | BECAMECEO | JOINED_CO | REJOIN | LEFTOFC | LEFTCO | RELEFT | PCEO | PCFO | TITLE | REASON | EXEC_LNAME | EXEC_FNAME | GENDER | PAGE | CUSIP | TICKER | NAICS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28943 | NaN | 0 | 0 | NaN | 31869 | CBRE GROUP INC | NaN | 366.000 | 585.000 | NaN | NaN | 951.000 | NaN | NaN | NaN | 1341.758 | 0.000 | 0.000 | 21.069 | 47.028 | NaN | NaN | NaN | 260774 | 30555 | 2004 | NaN | 2002-01-23 | NaN | NaN | NaN | NaN | NaN | NaN | Executive Chairman of Cbre-Asia Pacific | NaN | Blain | Robert | MALE | 67.0 | 12504L10 | CBRE | 531312 |
| 28944 | NaN | 0 | 0 | NaN | 31870 | CBRE GROUP INC | NaN | 458.000 | 663.000 | NaN | NaN | 1121.000 | NaN | NaN | NaN | 1286.484 | 1.646 | 0.000 | 35.764 | 28.328 | NaN | 11.643 | NaN | 260774 | 30556 | 2004 | NaN | 2003-07-23 | NaN | NaN | 2005-06-30 | NaN | NaN | NaN | former president-EMEA | RESIGNED | Froggatt | Alan | MALE | NaN | 12504L10 | CBRE | 531312 |
| 28945 | NaN | 0 | 0 | NaN | 31871 | CBRE GROUP INC | NaN | 225.000 | 189.800 | NaN | NaN | 414.800 | NaN | NaN | NaN | NaN | 200.179 | 200.179 | NaN | NaN | NaN | NaN | NaN | 260774 | 30557 | 2004 | NaN | 2004-04-26 | NaN | NaN | NaN | NaN | NaN | NaN | executive vp & general counsel | NaN | Midler | Laurence | MALE | 58.0 | 12504L10 | CBRE | 531312 |
| 28946 | NaN | 1 | 0 | NaN | 31865 | CBRE GROUP INC | CEO | 608.463 | 1968.900 | NaN | NaN | 2577.363 | NaN | 46.0 | 1.0 | 3622.316 | 0.000 | 0.000 | 10.630 | 13.741 | NaN | -4.564 | NaN | 260774 | 30552 | 2005 | 2005-06-01 | NaN | NaN | 2012-11-30 | NaN | NaN | NaN | NaN | Director | NaN | White | W. | MALE | 62.0 | 12504L10 | CBRE | 531312 |
| 28947 | NaN | 1 | 0 | NaN | 31866 | CBRE GROUP INC | NaN | 416.155 | 882.789 | NaN | NaN | 1298.944 | NaN | 62.0 | 2.0 | 1327.647 | 0.857 | 0.000 | -35.976 | -51.496 | NaN | -65.307 | NaN | 260774 | 30553 | 2005 | 2001-09-01 | NaN | NaN | 2005-06-02 | 2007-06-02 | NaN | NaN | NaN | former CEO | RETIRED | Wirta | Ray | MALE | 79.0 | 12504L10 | CBRE | 531312 |
| 28948 | NaN | 0 | 0 | NaN | 31867 | CBRE GROUP INC | NaN | 450.000 | 592.200 | NaN | NaN | 1042.200 | NaN | 50.0 | 4.0 | 1555.000 | 0.000 | 0.000 | 0.000 | 8.337 | NaN | 13.372 | NaN | 260774 | 21562 | 2005 | NaN | 2002-06-13 | NaN | NaN | 2008-11-30 | NaN | NaN | NaN | former senior executive vp & chief finance officer | RESIGNED | Kay | Kenneth | MALE | 67.0 | 12504L10 | CBRE | 531312 |
| 28949 | NaN | 0 | 0 | NaN | 31868 | CBRE GROUP INC | NaN | 500.000 | 762.000 | NaN | NaN | 1262.000 | NaN | 49.0 | 3.0 | 1929.498 | 0.857 | 0.000 | 11.111 | 4.852 | NaN | NaN | NaN | 260774 | 30554 | 2005 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Global Group President of Geographies | NaN | Frese, Jr. | Calvin | MALE | 65.0 | 12504L10 | CBRE | 531312 |
| 28950 | NaN | 0 | 0 | NaN | 31869 | CBRE GROUP INC | NaN | 383.437 | 499.896 | NaN | NaN | 883.333 | NaN | 50.0 | 5.0 | 1541.615 | 0.000 | 0.000 | 4.764 | -7.115 | NaN | 14.895 | NaN | 260774 | 30555 | 2005 | NaN | 2002-01-23 | NaN | NaN | NaN | NaN | NaN | NaN | Executive Chairman of Cbre-Asia Pacific | NaN | Blain | Robert | MALE | 67.0 | 12504L10 | CBRE | 531312 |
| 28951 | NaN | 0 | 0 | NaN | 31870 | CBRE GROUP INC | NaN | 389.250 | 472.290 | NaN | NaN | 861.540 | NaN | NaN | 6.0 | 863.033 | 1.493 | 0.000 | -15.011 | -23.145 | NaN | -32.915 | NaN | 260774 | 30556 | 2005 | NaN | 2003-07-23 | NaN | NaN | 2005-06-30 | NaN | NaN | NaN | former president-EMEA | RESIGNED | Froggatt | Alan | MALE | NaN | 12504L10 | CBRE | 531312 |
| 28952 | NaN | 0 | 0 | NaN | 31871 | CBRE GROUP INC | NaN | 325.000 | 214.700 | NaN | NaN | 539.700 | NaN | 41.0 | 7.0 | 962.208 | 12.268 | 11.700 | 44.444 | 30.111 | NaN | NaN | NaN | 260774 | 30557 | 2005 | NaN | 2004-04-26 | NaN | NaN | NaN | NaN | NaN | NaN | executive vp & general counsel | NaN | Midler | Laurence | MALE | 58.0 | 12504L10 | CBRE | 531312 |